Backup MySQL Database

[sped1530]

Will this backup everything including images, att. ect....?

[ideasgirl]

Will this backup everything including images, att. ect....?

No, only database (hence the name).

[sped1530]

How can you backup the product images and that kind of thing. I can use ez-pop to dump the data base or at least what I need to restore my inventory. Little worried about all those images I put in.

[ideasgirl]

You can use other mods like:
http://www.zen-cart.com/index.php?ma...oducts_id=1646

And you can use FTP to just download all the images folder to your computer.

[ideasgirl]

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.

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.

Ok, for the benefit of any other person with same issue. I found the problem. The DATABASE PASSWORD was containing the symbol "@" and apparently that contributed to the issue.

[Thannaree]

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

I ran into the same problem. I finally fixed it by simply removing the currency sign $ from the database password.

[Stuff4Toys]

I ran into the same problem. I finally fixed it by simply removing the currency sign $ from the database password.

ME TOO

I had both a $ and & in the password; and now after removing, it works perfectly.

[SPH]

I have same problem. How do you change the db password?

[Thannaree]

I have same problem. How do you change the db password?

Access you host cpanel, then go to Databases > MySQLDatabases

Under Current Database, check which username access your zencart database.

Go to the bottom of the page Under Current Users, click on that username and change your password as needed on the next page.

Change the password in your 2 config files accordingly.

[CybaGirl]

I have same problem. How do you change the db password?

Firstly put your store into Maintenance mode. Then download a copy of your configure.php file located in your "includes" directory using your FTP program.

Get yourself a decent text editor like EditPad (free and the best text editor there is IMO):

http://www.editpadlite.com/

Open up your configure.php and look for the following lines or if you are using Edit Pad Lite. Press CTRL F11 and EditPad Lite will add line numbers for you and in this case look for line 55 which is where your password should be. If not look below.

/ define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'DATABASE_USERNAME');
  define('DB_SERVER_PASSWORD', 'YOUR_PASSWORD');
  define('DB_DATABASE', 'DATABASE_NAME');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');

Change your password where I have written YOUR_PASSWORD

Once you have done this log into your hosting's control panel and scroll down till you see Databases.

Click on MySQL Databases then when this page loads scroll to the bottom and click on the user name that has been assigned to your database (see above in the section that says DATABASE _USERNAME or if using EditPad lite this should be line 54.

Once you have clicked on the user name a page will then load in which you can change the password. On this page you enter in the new password that you added to your configure.php you will also need to know your previous password. So make a note of it before changing the configure.php

Once you have done this don't exit your control panel just yet as you may need to use the file manager.

Save and upload the changes made to your configure.php. Your server may or may not allow you to upload the new file. If this is the case. Normally by deleting or better yet rename your configure.php file to something like configure.BAK then you should be able to upload your updated configure.php file.

Once this is done don't forget to change the permissions. CHMOD it to 444 again your server may or may not allow you to do this. If you can't CHOMD your file to 444 then do it via your control panel.

Now to do this. Go back to the main page in your control panel and look for the heading Files. Once you have found this click on where it says File Manager a little window might pop up and ask you which directory you want to start with. Just choose Home Directory and press Go.

A new page will load and from here select public_html on the left side of the page, then select the includes folder and then on the right side of the page select configure.php then right click on the file and choose Change Permissions then down the bottom in boxes you will see numbers perhaps in the combination of 644. Just change these numbers to 444 and press the Change Permissions button and you should be good to go!

You will also need to do this for the configure.php file located in your admin directory as well.

Don't forget to put your store back online

If you get stuck just let me know.