[Plugin: WP-InstantBackup] Backup Database Success, but result Blank

jinbatsu
(@jinbatsu)

15 years, 1 month ago

Hello,

This is a simple great backup system. I like this.
But after I try to do for backup mysql database.
The proccess and report is OK, Backup has successfull.
And also I have receive the file in my email and also in FTP account.

But after I open, the file is Blank with 0 byte after I extract the Zip.
I’m using password. I will try with no password if this can.

Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

(@el_baby)

I have the exact same problem. May it be related to the fact that the database server is not on the same host as the web server?

el_baby

(@el_baby)

15 years ago

Well… that was exactly the problem. It was easy to fix, though. Here’s a patch for subversion:

// create database backup sql file and zip it up
         if($backupType=='db' || $backupType=='full'){
             // backup database
-            $backupCommand    = "mysqldump -u ".DB_USER." --password=".DB_PASSWORD." ".DB_NAME." > ".$dbBackupSQLFilepath; // credentials from Database.cfg.php
+            if (!defined('DB_HOST')) define('DB_HOST','localhost');
+            $backupCommand    = "mysqldump -u ".DB_USER." --password=".DB_PASSWORD." --host=".DB_HOST." ".DB_NAME." > ".$dbBackupSQLFilepath; // credentials from Database.cfg.php
             exec($backupCommand);
             // if the database backup file we just created doesnt exist, error out
             if(!file_exists($dbBackupSQLFilepath)){

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: WP-InstantBackup] Backup Database Success, but result Blank’ is closed to new replies.