Backup MySQL Database

[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.

[SPH]

Thanks to both of you! I'll give it a try soon. My DB backup mod works on all my sites but my main one, and after seeing this thread now I think it is due to the strange characters in the pw (which I kind of suspected).

sph
www.prommart.com
www.fashion-mart.biz

www.prom-mart.com (testing area)

[Serious]

ZC v1.50
I downloaded (have not installed yet) based on the install instructions for EP 4.0.

Is it necessary/recommended to run this plug-in on my localhost prior to installing on my live site?

[DrByte]

Not sure what EP 4.0 has to do with it.

Doesn't matter if you install on localhost first or on live site first. Depends how/when you want to use it. There is no "problem" created by doing it "before" or "after".

If you want to install this plugin on your localhost, then you can use it to make a database backup.
If you don't, then you will need to use some other method of making a database backup.

[lhungil]

... I fixed it by removing any $,!,&, etc from the password. After removing, it works perfectly.

May have a working fix for this which does not require you to change your passwords to remove punctuation. The following is working correctly in my test and production environments (LAMP stacks).

Try changing line 125 of "admin/backup_mysql.php" from:

        $dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';

to:

        $dump_params .= ' --password=\'' . DB_SERVER_PASSWORD . '\'';

[rgriese]

Is there a way to use Backup MySQL Database tool to actually backup the true data files as well? ie. Customer, Order, etc. ?