phpMyAdmin在尝试导出数据库时显示空白页面？

Question

Recently I uninstalled the Wamp Server and re-installed the newer version of Wamp Server which is 3.1.3

Note: I am using Windows 10

Below are all the details of Wamp Server:

Apache Version: 2.4.33  
PHP Version: 5.6.35
MySQL Version: 5.7.21 
phpMyAdmin Version: 4.7.9

When I click on MYSQL Database in phpMyAdmin and then click on Export, the phpMyAdmin shows blank page. However, when I click on Import, phpMyAdmin doesn't show blank page at all. But the strange thing is when clicking on Export, phpMyAdmin shows Blank Page.

Since, I'm trying to export a Database from phpMyAdmin, I need to make sure that the page doesn't go blank when clicking on "Export" button.

I'm not sure regarding how to approach this problem because I'm very new in phpMyAdmin.

Would be really helpful if any recommended advice or solution is provided.

Answer 1

If you want to export the database using Command Line, then in that case, you can use mysqldump command.

If it's an entire DB, then:

   $ mysqldump -u [uname] -p[pass] db_name > db_backup.sql

If it's all DBs, then:

   $ mysqldump -u [uname] -p[pass] --all-databases > all_db_backup.sql

If it's specific tables within a DB, then:

   $ mysqldump -u [uname] -p[pass] db_name table1 table2 > table_backup.sql

You can even go as far as auto-compressing the output using gzip (if your DB is very big):

   $ mysqldump -u [uname] -p[pass] db_name | gzip > db_backup.sql.gz

---

uname - Username of database
pass - Password of database

You can check this answer

If you are using Windows then you need to change directory to C:\wamp\bin\mysql\mysql-version\bin and do above steps.