MySQL Forums
Forum List  »  Data Recovery

Re: Inactive server, same computer
Posted by: Peter Brawley
Date: November 18, 2016 02:19PM

Such attitude won't encourage helpful responses.

Unfortunately your posts have been unclear, and short on specifics. Restore is mostly about specifics.

If the partition's files can be accessed, but MySQL won't run on the partition, the first choice is to try to get MySQL running, which is why I inquired about that. If fixing that is actually impossible, you are limited to physical restore methods as described at http://dev.mysql.com/doc/refman/5.7/en/backup-types.html.

Physical & logical restore operations are extremely vulnerable to MySQL version differences. Restoration to the identical version is obviously least error-prone.

You've provided too little detail so far for responses to be other than general. Physical restore is easier for myisam than for innodb data. How and what to copy depends on if and how the server used the innodb storage engine, as described at

http://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
https://www.percona.com/services/support/percona-emergency-support
https://code.google.com/archive/p/innodb-tools/

Options: ReplyQuote


Subject
Views
Written By
Posted
1539
November 16, 2016 11:49AM
789
November 17, 2016 11:53AM
674
November 18, 2016 12:34PM
Re: Inactive server, same computer
990
November 18, 2016 02:19PM


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.