CODEWITHSUNDEEP
phpmysqlphpmyadmin
user3734074
user3734074

Reputation: 46

Phpmyadmin "Error in processing request" when export table - Error code 500

I'm trying to use PhpMyAdmin v. 4.5.3.1 to access a DB on a localhost and export a table but it is not working. I can access the DB, insert, search, etc. but when I click on "Export" tab it gives me this message:

enter image description here

I don't have this issue with PhpMyAdmin 4.2.6 using the same WAMP....

Does anyone knows how to fix it?

Thank you!

Upvotes: 2

Views: 3343

Answers (2)

Disha Goyal
Disha Goyal

Reputation: 624

You could fix this error by increasing memory limit to your requirement and restart httpd/apache service. I fixed it sometimes by increasing memory_limit. But now i prefer to use terminal commands only to handle it. Its better to always get habitual using terminal commands for doing such big operations in mysql. You get speed and more control over it as you are not dependent upon GUI based systems.

  1. Use mysqldump in terminal to export data: mysqldump -u root -p db_name > /home/dump.sql

  2. Use mysqldump in terminal to export only schema without data: mysqldump -u root -p db_name --no-data > /home/dump.sql

Upvotes: 0

clean_coding
clean_coding

Reputation: 1166

I think you should use mysqldump instead, when exporting data. From the command line:

mysqldump -uMYSQL-USER -h server -pMYSQL-USER database_name > /path-to-export

Or from a script:

$command = "mysqldump -uMYSQL-USER -h server -pMYSQL-USER database_name > /path-to-export/file.sql";
exec($command, $output, $return_var);

This can easily be automated.

Upvotes: 2

Related Questions