导入数据库时 PMA-SQL-ERROR [英] PMA-SQL-ERROR while importing database
本文介绍了导入数据库时 PMA-SQL-ERROR的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在 xampp 中导入数据库时出现这些错误
SQL 查询:
<div class="error"><h1>错误</h1><p><strong>SQL 查询:</strong><a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60berty12_embrace%60+WHERE+Name+%3D+%27wp_pTC_logs%27&show_query=1&db=berty12_embrace&token=753b2640358f750ff66cbbe34e72abd6"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit"/>编辑</span></a></p><p><code class="sql"><pre>从berty12_embrace"显示表状态,其中名称 = 'wp_pTC_logs'</pre></code></p><p><strong>MySQL 说:</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><代码>#2006 - MySQL 服务器已经消失</code><br/>
错误:
<块引用>1064 - 您的 SQL 语法有错误;检查与您的 MySQL 服务器版本相对应的手册,以获取在 ' 附近使用的正确语法
错误
第 1 行的 SQL 查询
解决方案
该错误是由超出以下 MySQL 设置之一引起的:
wait_timeoutmax_allowed_packet
您的主机或服务器人员需要在 MySQL 中增加这些设置.这里有更多信息:
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
While importing database in xampp I get these errors
SQL query:
<!-- 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+%60berty12_embrace%60+WHERE+Name+%3D+%27wp_pTC_logs%27&show_query=1&db=berty12_embrace&token=753b2640358f750ff66cbbe34e72abd6"><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 `berty12_embrace` WHERE Name = 'wp_pTC_logs'
</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>
Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
Error
SQL query at line 1
解决方案
That error is caused by one of these MySQL settings being exceeded:
wait_timeout
max_allowed_packet
Your host or server person needs to increase these settings in MySQL. There is more info here:
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
这篇关于导入数据库时 PMA-SQL-ERROR的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文