500 error on phpmyadmin export on /phpmyadmin/export.php

500 error on phpmyadmin export on /phpmyadmin/export.php

In this post, I will let you know the solution of exporting database from phpmyadmin.

This error occurs when you have updated your PHP version, phpmyadmin donot allow to export database file and shows following error :

500 error on phpmyadmin export on /phpmyadmin/export.php

After lots of searching, I got a solution, go with the Apache error log file :

PHP Fatal error: Cannot ‘break’ 2 levels in /usr/share/phpmyadmin/export.php on line 864

So go to the "/usr/share/phpmyadmin/export.php" file and change break 2; by break;.

If you are running on Ubuntu server, you can run following command to edit the export.php file :

sudo nano /usr/share/phpmyadmin/export.php

Search for ” (! $export_plugin->exportDBFooter($db)) {” and change the "break 2" by "break".

Now restart apache and mysql and it should fix the issue.

sudo service apache2 restart

sudo service mysql restart

Phone: (+91) 8800417876
Noida, 201301