Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unhappy Unanswered: database recovery

    I had MySql 4.0.9 installed on a linux machine but i messed up the server while upgrading a new kernel. Fortunately, I had a backup of the entire mysql installation directory. So I copied it over to a different machine and this machine has MySql 4.1.0 installed. I assume that since I have the "data" directory, all the database I have been using can be recovered. The problem is I cant seem to find any information about how to go about this. I would really appreciate if any1 can tell me where i can look for how to do this. Many thanks to you all!

  2. #2
    Join Date
    Jan 2004
    Posts
    3
    It seems copying the data directory into new installation's data directory brings databases back. but when I try to use it(use backupDB1), it is says,


    mysql> show databases;
    +----------+
    | Database |
    +----------+
    | backupDB1 |
    | mysql |
    | test |
    +----------+

    mysql> use backupDB1
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Didn't find any fields in table 'table01'
    Didn't find any fields in table 'table02'
    Didn't find any fields in table 'table03'
    Database changed
    mysql>

    Any help would be appreciated!

  3. #3
    Join Date
    Jan 2004
    Posts
    3
    haha stupid me.. i turns out the problem was directory permission. once i changed it, it read the tables correctly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •