从 .frm 文件恢复 mysql 数据库

2021-11-20 00:00:00 mysql mysqldump

我每周都转储我所有的桌子以获得备份.但后来我明白它只是存储表的 .frm 文件.它不显示表的 .MYD 和 .MYI 文件.所以我只有我的数据库的 .frm 文件,而且我的数据库是 innodb.那么我可以用数据库中的数据获取我的数据库吗?

I have dumped all my tables everyweek to got the backup. But later I understand that it is only storing the .frm file of the table. It is not showing .MYD and .MYI files of a table. So I have only my .frm file of the database with me and also mydatabase is innodb. So can I get my database with data in the database?

推荐答案

是的,这是可能的.仅将 .frm 文件复制到数据库文件夹还不够,还需要将 ib_logfilesibdata 文件复制到您的数据文件夹.我刚刚复制了 .frm 文件并复制了这些文件,然后重新启动服务器,我的数据库就恢复了.

Yes this is possible. It is not enough you just copy the .frm files to the to the databse folder but you also need to copy the ib_logfiles and ibdata file into your data folder. I have just copy the .frm files and copy those files and just restart the server and my database is restored.

复制以上文件后执行以下命令-

After copying the above files execute the following command -

sudo chown -R mysql:mysql/var/lib/mysql

sudo chown -R mysql:mysql /var/lib/mysql

上面的命令会将mysql下的文件所有者及其文件夹更改为MySql用户.这对于 mysql 读取 .frmibdata 文件很重要.

The above command will change the file owner under mysql and it's folder to MySql user. Which is important for mysql to read the .frm and ibdata files.

相关文章