phpmyadmin exports html not sql

Question

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.

Thank you.

Lyle

Answer 1

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

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.

Answer 2

I had the same problem. You can create a view for the result, then export data from that view. It worked for me.