Database Failed To Download

  • Hi, thanks for this niche plugin and i just have 1 issue and 1 question to say.

    ISSUE. If i try to download backup file from my WP Dashboard “Manage Backup Database” into my hard-disk then it fails download after 90%, but if i try to download direct from cPanel : for example – “public_html/wp-content/backup-db” then download will success 100%.
    So please find this download issue and i never tested anytime to restore backup file from your plugin, so yet i can’t tell if it success 100% or not …

    QUESTION. If i Backup Database from your plugin then file size is 40MB in sql format and if i download direct from cPanel : for example – “Backup Wizard / Download MySQL Databases – OR – phpmyadmin” then file size will be 8MB in same sql format, so what is the different between?

    Thanks.

    https://www.ads-software.com/plugins/wp-dbmanager/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Lester Chan

    (@gamerz)

    Probably check your logs? This is the first time I heard of problem downloading though.

    WP-DBManager uses mysqldump application to generate the backup and mysql application to restore them via shell while PHP uses PHP to generate the MySQL DUMP. So technically, mysqldump is a more efficient way of doing it

    Thread Starter S o f t f u l l y

    (@softfully)

    Ok, thanks for reply. Now last common question is how to restore backup file created by your plugin through “phpMyAdmin”?
    This question is important because if something happens wrong then WP will not open, so we have to do this restore step by “phpMyAdmin” directly. So please tell me the perfect step by step…

    Thanks

    Plugin Author Lester Chan

    (@gamerz)

    you can restore through phpmyadmin but it is not tested.

    My plugin is technical, if you are not comfortable with it, I recommend you to use an alternative plugin like https://www.ads-software.com/plugins/wp-db-backup/

    Here is the command line to restore it via SSH.

    You can upload your database file databasename.sql.gz to your server and run the command below, the wordpress is your DB username the second wordpress is your DB password and the third wordpress is your DB name

    gunzip < databasename.sql.gz | /usr/bin/mysql -u wordpress -pwordpress wordpress

    Thread Starter S o f t f u l l y

    (@softfully)

    Thanks, i am comfortable with you and your plugin because it’s simple and sober.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Failed To Download’ is closed to new replies.