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.
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.
If you're using Ubuntu. That problem caused by, you have not installed libapache2-mod-php. So, install with :
$ sudo apt install php libapache2-mod-php
then restart apache
$ sudo service apache2 restart