Backup MySQL Database

[g2ktcf]

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

[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)

[jodean]

I just tried the backup mysql on my new 2.0.1 upgrade and it just gives a blink to the admin page and returns to the admin page. Has anyone successfully install it?

[swguy]

Please post the debug log file from the /logs folder. It has been tested and should work.

[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.