douxie1894
2018-08-28 18:37 阅读 379
已采纳

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

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.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    douxing9641 douxing9641 2018-08-28 18:50

    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.

    点赞 评论 复制链接分享
  • douhuai4155 douhuai4155 2018-08-28 18:42

    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
    
    点赞 评论 复制链接分享

相关推荐