MySQL Forums
Forum List  »  Backup

Re: MYSQL Manual Backup - From Faulty Hard Disk
Posted by: Rick James
Date: January 23, 2015 05:55PM

I think it is possible.

You have access to the old disk drive? Do you know were MySQL's directory tree was? If not, search for files named *.MYD .

Given that (1) the tables were Engine=MyISAM, and (2) that you found those files, then you can copy the directory (probably only one) that the MYD files are in. Caution: You will find two (maybe more) such directories, one will be called "mysql" -- ignore that one, and grab the other one (it may have a name like "wp" for wordpress).

Copy that one directory to the new machines, and poof!, the blogs will be there.

Alas, there are still login issues; it is unclear (to me) how you can reconstruct the users' logins.

If you get this far, let us know; maybe we (or a WP forum) can help you the rest of the way.

Options: ReplyQuote

Written By
Re: MYSQL Manual Backup - From Faulty Hard Disk
January 23, 2015 05:55PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.