https://iphwiki.net/index.php?title=MySQL_-_%D0%BD%D0%B5_%D1%81%D1%82%D0%B0%D1%80%D1%82%D1%83%D0%B5%D1%82_%D1%81_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%BE%D0%B9_InnoDB:_Error:_could_not_open_single-table_tablespace_file&feed=atom&action=history
MySQL - не стартует с ошибкой InnoDB: Error: could not open single-table tablespace file - История изменений
2024-03-28T10:03:30Z
История изменений этой страницы в вики
MediaWiki 1.35.0
https://iphwiki.net/index.php?title=MySQL_-_%D0%BD%D0%B5_%D1%81%D1%82%D0%B0%D1%80%D1%82%D1%83%D0%B5%D1%82_%D1%81_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%BE%D0%B9_InnoDB:_Error:_could_not_open_single-table_tablespace_file&diff=8733&oldid=prev
Admin iph в 09:24, 11 августа 2020
2020-08-11T09:24:28Z
<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="ru">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Версия 09:24, 11 августа 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28" >Строка 28:</td>
<td colspan="2" class="diff-lineno">Строка 28:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> # mysqldump db_shop1 > /root/db_shop1.sql</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> # mysqldump db_shop1 > /root/db_shop1.sql</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> Далее удаляем db_shop1 и убираем опцию innodb_force_recovery, запускаем сервер MySQL.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> Далее удаляем db_shop1 и убираем опцию innodb_force_recovery, запускаем сервер MySQL.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> После этого создаем БД db_shop1 и делаем импорт из бекапа.</ins></div></td></tr>
</table>
Admin iph
https://iphwiki.net/index.php?title=MySQL_-_%D0%BD%D0%B5_%D1%81%D1%82%D0%B0%D1%80%D1%82%D1%83%D0%B5%D1%82_%D1%81_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%BE%D0%B9_InnoDB:_Error:_could_not_open_single-table_tablespace_file&diff=8732&oldid=prev
Admin iph в 09:23, 11 августа 2020
2020-08-11T09:23:50Z
<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="ru">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Предыдущая</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Версия 09:23, 11 августа 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21" >Строка 21:</td>
<td colspan="2" class="diff-lineno">Строка 21:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>означат, что база db_shop1 - битая. <br /></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>означат, что база db_shop1 - битая. <br /></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Решение - переводим сервер в режим innodb_force_recovery=1, делаем бекап этой БД, удаляем ее и запускаем сервер в нормальном режиме:</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Решение - <ins class="diffchange diffchange-inline">'''</ins>переводим сервер в режим innodb_force_recovery=1, делаем бекап этой БД, удаляем ее и запускаем сервер в нормальном режиме<ins class="diffchange diffchange-inline">'''</ins>:</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> # vi /etc/my.cnf.d/server.cnf</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> # vi /etc/my.cnf.d/server.cnf</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> [mysqld]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> [mysqld]</div></td></tr>
</table>
Admin iph
https://iphwiki.net/index.php?title=MySQL_-_%D0%BD%D0%B5_%D1%81%D1%82%D0%B0%D1%80%D1%82%D1%83%D0%B5%D1%82_%D1%81_%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D0%BE%D0%B9_InnoDB:_Error:_could_not_open_single-table_tablespace_file&diff=8731&oldid=prev
Admin iph: Новая страница: «=== MySQL - не стартует с ошибкой InnoDB: Error: could not open single-table tablespace file === Ошибка при запуске MySQL се…»
2020-08-11T09:22:30Z
<p>Новая страница: «=== MySQL - не стартует с ошибкой InnoDB: Error: could not open single-table tablespace file === Ошибка при запуске MySQL се…»</p>
<p><b>Новая страница</b></p><div>=== MySQL - не стартует с ошибкой InnoDB: Error: could not open single-table tablespace file ===<br />
<br />
<br />
Ошибка при запуске MySQL сервера - '''InnoDB: Error: could not open single-table tablespace file ./db_shop1/kmkx5_redcore_translation_tables.ibd''':<br />
InnoDB: The error means the system cannot find the path specified.<br />
InnoDB: If you are installing InnoDB, remember that you must create<br />
InnoDB: directories yourself, InnoDB does not create them.<br />
InnoDB: Error: could not open single-table tablespace file ./db_shop1/kmkx5_redcore_translation_tables.ibd<br />
InnoDB: We do not continue the crash recovery, because the table may become<br />
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.<br />
InnoDB: To fix the problem and start mysqld:<br />
InnoDB: 1) If there is a permission problem in the file and mysqld cannot<br />
InnoDB: open the file, you should modify the permissions.<br />
InnoDB: 2) If the table is not needed, or you can restore it from a backup,<br />
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal<br />
InnoDB: crash recovery and ignore that table.<br />
InnoDB: 3) If the file system or the disk is broken, and you cannot remove<br />
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf<br />
InnoDB: and force InnoDB to continue crash recovery here.<br />
<br />
<br />
означат, что база db_shop1 - битая. <br /><br />
Решение - переводим сервер в режим innodb_force_recovery=1, делаем бекап этой БД, удаляем ее и запускаем сервер в нормальном режиме:<br />
# vi /etc/my.cnf.d/server.cnf<br />
[mysqld]<br />
innodb_force_recovery=1<br />
# systemctl restart mysql<br />
# mysqldump db_shop1 > /root/db_shop1.sql<br />
Далее удаляем db_shop1 и убираем опцию innodb_force_recovery, запускаем сервер MySQL.</div>
Admin iph