#2006-MySQL服务器不见了 [英] #2006 - MySQL server has gone away
问题描述
首先，我想提一下，我已经进行了一些研究，发现了关于同一错误的以下问题:
First, I would like to mention that I have done some research and found the following questions about the same error:
- MySQL error 2006: mysql server has gone away
- (2006) MySQL server has gone away
- 2006: MySQL server has gone away
- MAMP - #2006 - MySQL server has gone away
这些问题和相应的答案都不符合我的情况.
None of these questions — and the corresponding answers — actually fit my situation.
我试图将我目前在OVH托管的WordPress网站从VPS迁移到仍然使用OVH的共享托管解决方案.
I am trying to move my WordPress site, currently hosted at OVH, from a VPS to a shared hosting solution, still with OVH.
不幸的是，我不能简单地更改托管计划，而需要通过FTP备份文件(完成)并导出数据库(当前问题).
Unfortunately, I cannot simply change my hosting plan, but need to backup my files through FTP (done) and export my database (current issue).
我试图通过PHPMyAdmin导出数据库，并首先尝试使用默认的quick选项(而不是custom选项).
I am trying to export the database through PHPMyAdmin and first gave a try to the default quick option (instead of the custom option).
一切似乎都运行顺利，我可以将数据库作为.sql文件下载.
Everything seems to run smoothly, and I can download my database, as a .sql file.
但是，当我打开此文件并转到底部以确保数据库导出完成时，我发现此错误消息:
However, when I open this file, and go at the bottom to make sure my database export was complete, I find this error message:
<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60madalanahyfr%60+WHERE+Name+%3D+%27wp_terms%27;show_query=1;db=madalanahyfr;token=ef02e420f3f2c53c8f08de662b74062b"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p>
<p>
<code class="sql"><pre>
SHOW TABLE STATUS FROM `madalanahyfr` WHERE Name = 'wp_terms'
</pre></code>
</p>
<p>
<strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div>
因此，看来我的数据库导出未完成，并且如果尝试将数据库文件导入到新的托管服务器中，恐怕会遇到麻烦.
So, it looks like my database export was not complete, and I am afraid that I will run into troubles if I try to import this database file into my new hosting.
任何想法在这里出了什么问题以及如何使事情起作用?
Any idea what is going wrong here and how to make things work?
推荐答案
那是一个损坏的导出，我完全不信任它.
That is a corrupt export, I wouldn't trust it at all.
该错误与MYSQL Server超时或连接中断有关，请通过以下链接阅读 MYSQL Docco ，然后尝试根据建议调整wait_timeout.也许您可以将导出分解成单个表.
That error is associated with a MYSQL Server Timeout or connection interruption, Please read through this link MYSQL Docco and try adjust the wait_timeout as suggested. Perhaps you could break the export up in to individual tables.
这篇关于#2006-MySQL服务器不见了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
