Backup MySQL Database: Result code: 2

[theapeman]

I have the Backup MySQL Database mod installed and I'm getting this error message every time I attempt a backup:

Result code: 2
Failure: The database has NOT been saved.

From searching the forums I see that the error messages others describe seem to include some additional info indicating the cause of the error, but I just get the two lines above and nothing more.

Also, as it happens, I have two separate Zen Carts running on this particular server, each on its own database, and the backup DB module works fine on my other cart. Other than content, the only difference I'm aware of is that the cart giving me the problems is a new install of 1.3.7.1 whereas the one that works is plain old 1.3.7.

At first I thought it might be my connection settings: Around the time I was building the second cart I was a bit paranoid about hackers so I created a non-root MySQL user with privileges only for that one DB, and those are the connection settings in configure.php. But then I remembered that I had actually gone back and retrofitted the first cart in the same way, so neither one is connecting as root, but the old cart works and the new one doesn't.

Thanks for any assistance.

[kobra]

Tripple check the folder permissions where this is to be saved

[DrByte]

Put it into debug mode and let's see what else is happening behind-the-scenes:

Open the MySQL Backup screen.
Click on Backup
change the URL by adding &debug=ON and press Enter
Now click the Backup button in the sidebox.
You should see a number of other status messages besides just the error you reported.
If you post it here, be sure to obfuscate your database password.

[theapeman]

The resulting output was:

Checking Path: /usr/bin/

COMMAND FILES SELECTED:
mysqlexe="/usr/bin/mysql"
mysqldumpexe="/usr/bin/mysqldump"

COMMAND: "/usr/bin/mysqldump" "--host=localhost" "--user=username" "--password=password" --opt --complete-insert "--result-file=/path/to/renamed/admindir/backups/db_my_database-20070802231551.sql" my_database 2>&1
Result code: 2
valueA:
valueB:
Failure: The database has NOT been saved.

Also the permissions on the backups directory are set to 777.

[DrByte]

Nothing obvious about the cause of the problem there.

Edit the /admin/backup_mysql.php file .. around line 152 you'll see:

        $resultcodes = @exec(OS_DELIM . $toolfilename . $dump_params . OS_DELIM, $output, $dump_results );

remove the @ sign in @exec(
Then try again. May want to do the debug=ON again.

You'll want to undo that edit once things are working though.

[theapeman]

Removed the @ and got the same output as before with debug ON. Without debug ON I just got the original two lines.

[DrByte]

Also, as it happens, I have two separate Zen Carts running on this particular server, each on its own database, and the backup DB module works fine on my other cart. Other than content, the only difference I'm aware of is that the cart giving me the problems is a new install of 1.3.7.1 whereas the one that works is plain old 1.3.7.

There should be no differences in how this plugin works between v1.3.7 and v1.3.7.1.
The module is compatible for all v1.2.x and v1.3.x releases.

At first I thought it might be my connection settings: Around the time I was building the second cart I was a bit paranoid about hackers so I created a non-root MySQL user with privileges only for that one DB, and those are the connection settings in configure.php. But then I remembered that I had actually gone back and retrofitted the first cart in the same way, so neither one is connecting as root, but the old cart works and the new one doesn't.

What are all the rights/permissions/grants settings for each of the database users ?

What happens if you grant user A to database B, and then use user A info in the site B admin/includes/configure.php ?