Backup MySQL Database

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

sped1530:

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

No, only database (hence the name).

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.

You can use other mods like:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1646

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

ideasgirl:

Having same exact issue here: :lamo:
-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.

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. :frusty:

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

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

Thannaree:

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.

:clap:

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

SPH:

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.

SPH:

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 :yes:

If you get stuck just let me know.

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
https://www.prommart.com
https://www.fashion-mart.biz

https://www.prom-mart.com (testing area)

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?

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.

As I stated in my op, it was recommended in the EP install instructions.

The second half of your reply answered my question well enough.

Am new to Zen Cart and trying to install Backup MySQL plugin. I need a little more detailed instructions on how to install. When I look at the client's file structure, there is no "admin" folder. Instead, what I see is attached. Is this the directory I would install the files to? Do I unzip the files I downloaded, just copy them, or what? Any help greatly appreciated.

Admin is renamed when ZC is installed. You need to determine what the new name is.
Your customer should be the person to ask.

Thanks, the customer won't know the answer to this question. Can you look at the file structure above to tell? She had 2 installs 1 for a wholesale site and 1 for retail. Under the wholesale folder is the folder that you can see in the attached screen shot, called Clay. This folder has the Backups, images, include folders etc. Assuming this is the correct folder, how to I extract the Zip file I downloaded to my pc into this folder. Can I just upload from the host's file manager? Thanks for any guidance.

I have installed the plugin in, however now when I go to tools and run it, I get the following message: Backup directory does not exist. Please set this in configure.php. And further down the page "Warning: dir(/kunden/homepages/37/d401359263/htdocs/wholesale/admin/backups/) [function.dir]: failed to open dir: No such file or directory in /homepages/37/d401359263/htdocs/wholesale/clay/backup_mysql.php on line 404" I think this is because my admin directory is actually "Clay" but how can I change the add-on so that it will create the backups in the /wholesale/clay/backups folder instead of looking for admin\backups. I'm apologizing in advance but I need pretty specific instructions. Thanks so much for any help!

DrByte or others, would you be able to help me with this?: I would really appreciate it :smile:

rgriese:

I have installed the plugin in, however now when I go to tools and run it, I get the following message: Backup directory does not exist. Please set this in configure.php. And further down the page "Warning: dir(/kunden/homepages/37/d401359263/htdocs/wholesale/admin/backups/) [function.dir]: failed to open dir: No such file or directory in /homepages/37/d401359263/htdocs/wholesale/clay/backup_mysql.php on line 404" I think this is because my admin directory is actually "Clay" but how can I change the add-on so that it will create the backups in the /wholesale/clay/backups folder instead of looking for admin\backups. I'm apologizing in advance but I need pretty specific instructions. Thanks so much for any help!

rgriese:

"Warning: dir(/kunden/homepages/37/d401359263/htdocs/wholesale/admin/backups/) [function.dir]: failed to open dir: No such file or directory
Note the directory above is NOT the same as your actual directory, shown below:
rgriese:

... in /homepages/37/d401359263/htdocs/wholesale/clay/backup_mysql.php

And this tells me that the paths in your /clay/includes/configure.php file are pointing to the old /kunden/..../admin/... folder, instead of the correct actual folder.