phpmyadmin export gives 0kb file
When you use phpmyadmin provided by plesk and you try to export a large database you may encounter the problem that it will always give you to download a file 0 kb.
This happens when the database is big and you need to increase some options in php.ini to make it work.
1.(for plesk users only )Â First of all find which php.ini phpmyadmin uses , you can do that by using a file for e.g. test.php with the code:<? phpinfo();?> then read the line: Configuration File (php.ini) Path
2.make a copy of the original file (for backup reasons) and then change the options:
max_execution_time,max_input_time,memory_limit , for a database 180 mb I did use the following and it worked:
max_execution_time = 72000Â Â Â ; Maximum execution time of each script, in seconds
max_input_time = 7600Â Â ; Maximum amount of time each script may spend parsing request data
memory_limit = 512MÂ Â Â Â Â ; Maximum amount of memory a script may consume (64MB)