1. <tfoot id='vVMy9'></tfoot>
  2. <i id='vVMy9'><tr id='vVMy9'><dt id='vVMy9'><q id='vVMy9'><span id='vVMy9'><b id='vVMy9'><form id='vVMy9'><ins id='vVMy9'></ins><ul id='vVMy9'></ul><sub id='vVMy9'></sub></form><legend id='vVMy9'></legend><bdo id='vVMy9'><pre id='vVMy9'><center id='vVMy9'></center></pre></bdo></b><th id='vVMy9'></th></span></q></dt></tr></i><div id='vVMy9'><tfoot id='vVMy9'></tfoot><dl id='vVMy9'><fieldset id='vVMy9'></fieldset></dl></div>

      <legend id='vVMy9'><style id='vVMy9'><dir id='vVMy9'><q id='vVMy9'></q></dir></style></legend>
        <bdo id='vVMy9'></bdo><ul id='vVMy9'></ul>

      <small id='vVMy9'></small><noframes id='vVMy9'>

      从 .frm 文件恢复 mysql 数据库

      时间:2023-06-02
      <i id='KeyDB'><tr id='KeyDB'><dt id='KeyDB'><q id='KeyDB'><span id='KeyDB'><b id='KeyDB'><form id='KeyDB'><ins id='KeyDB'></ins><ul id='KeyDB'></ul><sub id='KeyDB'></sub></form><legend id='KeyDB'></legend><bdo id='KeyDB'><pre id='KeyDB'><center id='KeyDB'></center></pre></bdo></b><th id='KeyDB'></th></span></q></dt></tr></i><div id='KeyDB'><tfoot id='KeyDB'></tfoot><dl id='KeyDB'><fieldset id='KeyDB'></fieldset></dl></div>

        <bdo id='KeyDB'></bdo><ul id='KeyDB'></ul>

          <legend id='KeyDB'><style id='KeyDB'><dir id='KeyDB'><q id='KeyDB'></q></dir></style></legend>
            <tbody id='KeyDB'></tbody>
          • <small id='KeyDB'></small><noframes id='KeyDB'>

                <tfoot id='KeyDB'></tfoot>

                本文介绍了从 .frm 文件恢复 mysql 数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                我每周都转储我所有的桌子以获得备份.但后来我明白它只是存储表的 .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.

                这篇关于从 .frm 文件恢复 mysql 数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                上一篇:MySQL 更新连接表 下一篇:Mysql:按like排序?

                相关文章

                <tfoot id='iB88H'></tfoot>
                1. <small id='iB88H'></small><noframes id='iB88H'>

                    <legend id='iB88H'><style id='iB88H'><dir id='iB88H'><q id='iB88H'></q></dir></style></legend>
                    <i id='iB88H'><tr id='iB88H'><dt id='iB88H'><q id='iB88H'><span id='iB88H'><b id='iB88H'><form id='iB88H'><ins id='iB88H'></ins><ul id='iB88H'></ul><sub id='iB88H'></sub></form><legend id='iB88H'></legend><bdo id='iB88H'><pre id='iB88H'><center id='iB88H'></center></pre></bdo></b><th id='iB88H'></th></span></q></dt></tr></i><div id='iB88H'><tfoot id='iB88H'></tfoot><dl id='iB88H'><fieldset id='iB88H'></fieldset></dl></div>

                      <bdo id='iB88H'></bdo><ul id='iB88H'></ul>