The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Restore old mysql files?

Discussion in 'General Discussion' started by hosterplus, May 22, 2007.

  1. hosterplus

    hosterplus Member

    Joined:
    Oct 13, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Hi Everyone,

    I had a hardrive failure the other day with no warning.

    I didn't have time to download a backup for one of our sites databases. Luckily I was able to copy the actual mysql files stored in var/lib/mysql .

    I setup the accounts today and restored the files but half of the databases are showing the message

    ""Table './[DB NAME IS HERE]/forum_topics' was created with a different version of MySQL and cannot be read" "

    the other tables read fine.

    Any ideas on how I can retrieve the data from the tables and then re-import it?

    Thanks in Advance!

    Sean
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Are you in fact running a different version of mysql after this backup was created?
    I would find a box with the version you had, dump the tables.
     
Loading...

Share This Page