phpmyadmin导出html而不是sql [英] phpmyadmin exports html not sql

问题描述

我有phpmyadmin 4.4.7，以前已将MySql表导出为.sql格式.但是，即使我使用快速"或高级"方法选择.sql格式，它现在也将以html格式导出.

I have phpmyadmin 4.4.7 and have previously exported MySql tables fine into .sql format. However, it is now exporting in html format even though I select .sql format with either Quick or Advanced method.

任何想法/建议都值得赞赏.

Any thoughts/suggestions much appreciated.

谢谢.

莱尔

推荐答案

当数据库很大(我的情况下超过300个表)时，Phpmyadmin无法正确导出.

Phpmyadmin does not export properly when the database is very large (more than 300 tables in my case).

我在资源限制"部分的末尾在php.ini中添加了以下内容:

I added the following inside php.ini at the end of the "Resource Limits" section:

max_input_vars = 5000;

现在可以了.更多信息此处.

now it works. More info here.

这篇关于phpmyadmin导出html而不是sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！