Backup MySQL Database

[lat9]

I am testing a site very similar to lat9 https://www.example.com/test. I am getting this error.

0 => mysqldump: Got error: 1045: "Access denied for user '************User'@'localhost' (using password: YES)" when trying to connect

Does your site's database password also include any "special" characters?

[g2ktcf]

I saw your issues with special characters (there are three). I have plans to change that and see if that works.

[g2ktcf]

After removing all special characters, this works just fine.

[carlwhat]

Does your site's database password also include any "special" characters?

speaking of special characters.....

if your admin directory has any special characters, it seems that the following change is necessary (for backing up... around line 133):

//from
$dump_params .= ' "--result-file=' . DIR_FS_BACKUP . $backup_file . '"';
//to
$dump_params .= ' "--result-file=' . escapeshellcmd(DIR_FS_BACKUP) . $backup_file . '"'; 

it may be worth wild to change all instances of DIR_FS_BACKUP to $backup_directory and define said var at the beginning of the script as such:

$backup_directory = escapeshellcmd(DIR_FS_BACKUP); 

but alas, i do not have the time or inclination at this moment for further testing.

[torvista]

Since I have modified this to death over the years, I've set up a new repository based on this plugins history to be able to add in changes at some point.

So please add this link to the plugin page for reporting issues:

https://github.com/torvista/Zen_Cart-Backup_MYSQL_Plugin

[torvista]

When doing a backup->Download without storing on server, I note that
- a dumpfile is created, ok
- a download window opens, ok
- the download occurs, ok
- another dumpfile is created, NOT ok.

After the header-exit, it seems to be re-running the same page using action backupnow, but despite my efforts I can't stop it.
Consequently every time I take a backup snapshot from the hosting for local use, it leaves behind 300Mb of debris which I need to delete manually.

(In my modified version of this plugin, the original dumpfile is unlinked after download, but still, a new one is created as per the plugin version)

[lat9]

Since I have modified this to death over the years, I've set up a new repository based on this plugins history to be able to add in changes at some point.

So please add this link to the plugin page for reporting issues:

https://github.com/torvista/Zen_Cart-Backup_MYSQL_Plugin

All finished.

[torvista]

Damn...now I suppose I'll have to do something with it!
Given the absence of comments here and there, looks like it is rarely used...I use it constantly.

[swguy]

Thanks folks.

Also note that since some hosters are allergic to this script, so you may have to resort to another option for building a backup.
You can use cPanel backup or backup via phpMyAdmin as noted in the documentation.

https://docs.zen-cart.com/user/runni...-your-database

[torvista]

I suppose the problem is in the use of exec.

I'd also point out my use case is I don't use this for production backups, that's a separate automated process.
I use this as a dev tool, to get a copy of production db for use locally, usually to test imports first, or to test install scripts/do repeated restores: much easier to in the admin than elsewhere. Invaluable in that respect.