Backup MySQL Database

Quote:

---

Originally Posted by 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.

https://www.shilohhosting.com:2083/c...themes/dot.gifServer: 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.