Help: recovery MySQL data on Linux.

This is the situation now
1: The Linux file under the Temps directory of the original, the whole system, including MySql, Temps/usr/local/mysql
2: Now re installed a key to LNMP, Temps under the original is so arranged, so the two directory structure is the same
3: Because Mysql data without manual backup, now only the documents are still
4: How to restore the database to the current Temps/usr/local/mysql/var/XXXXXX MySQL (usr/local/mysql/var/XXXXXX), XXXX free, directly copy the past, there is no table, only one library

Started by Dave at November 16, 2016 - 7:37 PM

Table engine is MYISAM COPY can directly, to find whether there is a ib*.* file

Posted by Burnell at November 18, 2016 - 7:56 PM

First determine the MySQL data directory you said position confirmation check the parameters of show variables like 'datadir'


If the data recovery of few G use the mysqldump export recovery

Posted by Goddard at December 01, 2016 - 8:34 PM

1 if the database is using the MyISAM table, can be directly copy, restart MySQL

2 if the use of InnoDB, can not be directly copy, can refer to this article

Posted by Gina at December 10, 2016 - 8:46 PM