CODEWITHSUNDEEP
phpmysqlapachephpmyadminwampserver
beginIT
beginIT

Reputation: 227

phpMyAdmin is showing blank page while trying to export a database?

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.

Upvotes: 2

Views: 3836

Answers (2)

akshaypjoshi
akshaypjoshi

Reputation: 1295

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.

Upvotes: 5

Eyad
Eyad

Reputation: 47

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

Upvotes: 0

Related Questions