Question posted in
Some documentation to get you started can be found here.

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

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.

Tags:

2

Answers


  1. 0

    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
    Login or Signup to reply.
  2. 0

    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:wampbinmysqlmysql-versionbin and do above steps.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search