Backup MySQL Database

shrimp-gumbo-mmmhhh:

Hello, I am using this plugin and have a VPS. This is working fine on one of my accounts but is not working on another. Here is the error messages: Running V1.56a works fine on one site but not this one. Any suggestions or thoughts? When I get on phpAdmin from this account this is the database server it is showing:

Server: localhost:3306 same as the working backup site.

Server: lo
Result code: 2
0 => mysqldump: Got error: 1045: "Access denied for user 'website'@'localhost' (using password: YES)" when trying to connect

Failure: The database has NOT been saved.

I'm have the exact same problem. Installed and working on one VPS but not working on another. Both on same hosting provider. Zencart 1.5.6a, php 7.3

I suspect the issue you are seeing is that on the site where it doesn't work, your password has shell metacharacters. Create a new password without these, update your configure.php files, and try again.

I thought I solved this problem but further testing showed that my fix was incomplete.

Google "shell metacharacters" if you don't know what these are, or just use numbers and letters (upper and lower case) in your new password.

Ha! I just spent about 30 minutes working with my host and turns out, as you also just suggested, that it does not like certain characters. In this case, it was my use of the semi-colon ";" ... Once I removed that, everything worked as it should.

Thanks for the reply. Hopefully this will help others that stumble into this problem!

I'll do some more testing and see if I can figure out a way to make this work. I think @mc12345678 also had some ideas on how to fix this problem so maybe he will chime in.

Long ago I did extensive testing with passwords and odd characters on Windows and Unix, and decided they needed different delimiters. I extensively modified this plugin, you may have more luck with that. It's in my Github.

swguy:

I suspect the issue you are seeing is that on the site where it doesn't work, your password has shell metacharacters. Create a new password without these, update your configure.php files, and try again.

I thought I solved this problem but further testing showed that my fix was incomplete.

Google "shell metacharacters" if you don't know what these are, or just use numbers and letters (upper and lower case) in your new password.

Yes, the working one is only letters and numbers while the nonworking may have a 1 or 2 shell metacharacters in it.

It now works after password change.

I am getting this error when I try to create a backup

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

How do i fix it?

mani:

I am getting this error when I try to create a backup

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

How do i fix it?
For starters, please identify the version numbers for: this plugin, Zen Cart and PHP.

mani:

I am getting this error when I try to create a backup

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

How do i fix it?

This means your database password, as specified in admin/includes/configure.php, has special characters in them. Change it to one without special characters and it will work.

swguy:

This means your database password, as specified in admin/includes/configure.php, has special characters in them. Change it to one without special characters and it will work.
Or modify the plugin such that the password is within quotes with the password immediately following the -p (no space to follow:

-p'" . DB_SERVER_PASSWORD . "'

With the possibility of needing to use addslashes() around the password constant.

I am receiving the following in error logs after installing Backup MySQL Database plugin v157?
Do you have any idea what is causing the error?

[19-Jul-2020 09:29:25 CST6CDT] Request URI: /shop_v157/my_admin_dir/index.php?cmd=backup_mysql&action=backup, IP address: 69.137.114.242
#1 require(/home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php) called at [/home/tennes60/public_html/shop_v157/my_admin_dir/index.php:11]
--> PHP Warning: Use of undefined constant ICON_FILE_DOWNLOAD - assumed 'ICON_FILE_DOWNLOAD' (this will throw an Error in a future version of PHP) in /home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php on line 439.

[19-Jul-2020 09:29:25 CST6CDT] Request URI: /shop_v157/my_admin_dir/index.php?cmd=backup_mysql&action=backup, IP address: 69.137.114.242
#1 require(/home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php) called at [/home/tennes60/public_html/shop_v157/my_admin_dir/index.php:11]
--> PHP Warning: Use of undefined constant IMAGE_RESTORE - assumed 'IMAGE_RESTORE' (this will throw an Error in a future version of PHP) in /home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php on line 461.

[19-Jul-2020 09:29:25 CST6CDT] Request URI: /shop_v157/my_admin_dir/index.php?cmd=backup_mysql&action=backup, IP address: 69.137.114.242
#1 require(/home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php) called at [/home/tennes60/public_html/shop_v157/my_admin_dir/index.php:11]
--> PHP Warning: Use of undefined constant IMAGE_BACKUP - assumed 'IMAGE_BACKUP' (this will throw an Error in a future version of PHP) in /home/tennes60/public_html/shop_v157/my_admin_dir/backup_mysql.php on line 500.

You can probably add this to the bottom of the plugin's language file to stop those warnings:

if (!defined('ICON_FILE_DOWNLOAD')) define('ICON_FILE_DOWNLOAD', 'Download');
if (!defined('IMAGE_RESTORE')) define('IMAGE_RESTORE', 'Restore');
if (!defined('IMAGE_BACKUP')) define('IMAGE_BACKUP', 'Backup');

What is the purpose of these errors and future errors warning?

jodean:

What is the purpose of these errors and future errors warning?
It's part of PHP's evolution. The PHP authors have been taking steps over the past few years to improve performance. Apparently the undefined-constants' checking at runtime was determined to be a bottle-neck.

Those messages are PHP's notice that an undefined constant was found and, for now, it's going to be interpreted as if the code had placed quotes around the constant name. Future versions of PHP will stop during the parsing step and issue an error if an undefined constant is discovered.

Can I do a sql backup using this tool on zen cart 1.55 then take that file and place into my new zen cart 1.57 sql /backups folder and restore it?
Any modules need to be updated to 1.57 as well I assume is that correct?
Or is this just the wrong way to upgrade using this tool to in hence upgrade the database?
Thx

spawnie69:

Can I do a sql backup using this tool on zen cart 1.55 then take that file and place into my new zen cart 1.57 sql /backups folder and restore it?
Any modules need to be updated to 1.57 as well I assume is that correct?
Or is this just the wrong way to upgrade using this tool to in hence upgrade the database?
Thx

Yes, but understand that upon restore of the old database into the new fileset that the database needs to be upgraded using zc_install... ideally also the backup was made when the store was in maintenance mode. Further, to truly retain records of store operation, once you've gotten familiar with what it will take to do the upgrade, then place the live site in maintenance mode, make the backup copy of the database, upload the backup, do zc_install on it, test, place back live

Hi,

Using the latest version from plugins and ZC 1.5.7. I had the password issue which I fixed by removing special characters but now I have the following warning after backing up.

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

The backup is saved and I can restore.

Googling I found https://forums.cpanel.net/threads/cpanel-33473-mysql-dump-process-privilege-error-after-5-7-31-update.675657/

Is this the cause and the fix?

Brent

Brent:

Hi,

Using the latest version from plugins and ZC 1.5.7. I had the password issue which I fixed by removing special characters but now I have the following warning after backing up.

The backup is saved and I can restore.

Googling I found https://forums.cpanel.net/threads/cpanel-33473-mysql-dump-process-privilege-error-after-5-7-31-update.675657/

Is this the cause and the fix?

Brent

Having similar issue. We moved a site from my VPS to its own VPS. After battling with the new host with the Exec() issue, now I'm getting this error. Customer is using:
ZC v1.5.6c
PHP Version: 7.2.33
MySQL 5.7.31

Any way to fix this?

In > admin\backup_mysql.php I added the following line ```php
$dump_params .= ' --no-tablespaces';

I have no idea if this is the correct thing to do so didn't post here but as nobody else has replied you could give it a go :smile: