Backup MySQL Database

[gsdcypher]

zen cart 1.3.9h
plugin v1-4
help please. after trying to run backup getting this error:

Result code: 2
Warning 0 => mysqldump: Got error: 1045: Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect
Error Failure: The database has NOT been saved.

thanks

[katco]

I just moved a zencart to a new server. Now when I go to use the MySQL backup, I see the option to download as gzip is gone. I can only select pure SQL. Is this because of some different configuration on the new host or did something get broken during the move? (the pure sql option seems to have worked fine)

[DrByte]

The gzip option is only presented if the feature is enabled on the server.

[katco]

Ok, so they showed me how to enable it and they showed me that it is now working but it is still not an option on my backup.

[katco]

Weird. If I back up to the server, I am getting a gzipped file even though the only button is for pure sql. But if I download to my computer then I am getting it as a pure sql and have no option for gzip.

So what I am really missing is the radio button to select the type I want, I guess. Anyone know why that would be?

[yesaul]

Hello,

When backup, I'm gettin a message:

0 => Warning: mysqldump: Option '--set-variable' is deprecated. Use --variable-name=value instead.


How can I fix this?


BR, AR

[Out2lunch]

 Result code: 137
 0 => Killed
 Failure: The database has NOT been saved.

MySQL error code 137: No more records (read after end of file) - from here -> http://rackerhacker.com/2007/08/09/mysql-error-codes/


---

This is a new one to me, ive been using this addon for 2+ years and never had an issue with it. Just upgraded to 1.4 and now Houston we have a problem.

Can anyone shed any light on this issue???


Cheers

[SPH]

Access denied for user 'xxxxxx'@'localhost' (using password: YES) when trying to connect

Get above error on one of my domains. I have couple other zencarts on same server, mod works without error.

Thoughts?

Thanks.

sph
www.prommart.com

[ideasgirl]

Result code: 2
Warning 0 => mysqldump: Got error: 1045: Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect
Error Failure: The database has NOT been saved.

Having same exact issue here:
-4 Zen Cart hosted on VPS
-2 of them upgraded from 1.3.8a to 1.3.9h
-1 has module installed and working just fine
-the other one is giving this error when I try to backup.

More related info:
PHP Version: 5.2.11 (Zend: 2.2.0)
Database Data Size: 6,912 kB
Database: MySQL 5.0.92-community
PHP Safe Mode: Off
MySql Version 5.0.92

I don't see the path to mysqldump on the info page, where can I see it? Even though I don't think that's the problem since the other site on same server is working just fine and I didn't change anything on the files.

[DrByte]

If mysqldump is the problem, then it's ONLY a problem if it's an out-of-date version.

More likley your database user permissions are the problem. Your user doesn't have permissions to connect via 'localhost'.
Ask your host for help on solving the database-user credentials problem in MySQL.