Backup MySQL Database

[DrByte]

Any downloads you do from this page will not be encrypted. Doing backups and restores will be fine, but download/upload of files from/to the server presents a security risk"

1. As the message said, doing backups and restores will be fine.

2. The entire message will disappear once you fix the SSL issues you have with your site. You're already discussing them in another thread, so let's leave that discussion over there. Securing your Admin is as simple as using https URLs in your admin configure.php. Again, discuss it in the OTHER thread where you're already sorting that out.

[Lopi]

Hi, after install I have this problem
Result code: 1
0 => '"mysqldump"' is not recognized as an internal or external command,
1 => operable program or batch file.
Failure: The database has NOT been saved.
zen 1.5.5.e any idea ?

[DrByte]

Hi, after install I have this problem
Result code: 1
0 => '"mysqldump"' is not recognized as an internal or external command,
1 => operable program or batch file.
Failure: The database has NOT been saved.
zen 1.5.5.e any idea ?

That suggests that the server doesn't have the mysqldump binary installed. Your hosting company may not have installed it.

[twitchtoo]

Zen Cart 1.55e, newest version available v5d of the plugin fails backup. It goes through the motions with any selected option or combination and a 58 byte properly named and saved file is created or downloaded depending on the selections. The files are all empty.

On page reload the 1045 error posts in the admin header.

Works less now on 1.55e than it did before the update also my previous posts #169 #168 have not been corrected.

Poses the question what does this actually work on and has it been properly tested?

[torvista]

has it been properly tested?

Couldn't say, I did a lot of changes to that a long time ago. As usual I got carried away and made so many changes I never got round to uploading it.
Works for me, on my Github. Comments welcome.

[swguy]

@twitchtoo Can you post some information on your environment? (OS, PHP version, MySQL version, etc.) I will check.
Are you saying 1.5c did work and 1.5d does not work?

[twitchtoo]

@twitchtoo Can you post some information on your environment? (OS, PHP version, MySQL version, etc.) I will check.
Are you saying 1.5c did work and 1.5d does not work?

Client one:
Zen Cart 1.55e
Linux 2.6
Php 5.6
MySQL 5.5
Backup MySQL Database version 1.5c - works in one button position only - referred to in previous post #168-169


Client two:
Zen Cart 1.55f
Linux 2.6
Php 7.1
MySQL 5.6
Backup MySQL Database version 1.5c - works in one button position only - referred to in previous post #168-169


Client one and two update to Backup MySQL Database version 1.5d
- posts only 58 byte file backups

[swguy]

Then I guess I'm stumped. You can see that the differences between 5c (left) and 5d (right) are small.

125c125
<         $dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';
---
>         $dump_params .= ' "--password=' . escapeshellcmd(DB_SERVER_PASSWORD) . '"';
258c258
<         $load_params .= ((DB_SERVER_PASSWORD =='') ? '' : ' "--password=' . DB_SERVER_PASSWORD . '"');
---
>         $load_params .= ((DB_SERVER_PASSWORD =='') ? '' : ' "--password=' . escapeshellcmd(DB_SERVER_PASSWORD) . '"');

Can you do some testing with escapeshellcmd on your system and check the results? This works fine for me in similar environments.

[swguy]

Maybe try changing it to escapeshellarg() but remove the single quotes around the argument.