Zencart store backup

Posted in Tutorials

Tweet This Share on Facebook Bookmark on Delicious Digg this Submit to Reddit

Your ZenCart eCommerce store consists of server side PHP files that makes your store work and the MySQL database that contains all your product, orders, customers, and settings data. You should have an initial backup of both. Then as you get more customers and order and add new products, you need to continue to backup your MySQL database on a regular basis.

Backing Up PHP files

To backup the PHP source files, FTP to your webhosting server and download all the files and all the subdirectories of your installed ZenCart folder off to a safe location.

Some webhosts may have other methods of backup. For some webhosts, you can click the “Backup” feature icon in your control panel and click the link “Download a Home Directory Backup”.

Backing Up MySQL Database

To backup the MySQL databse, you will have to use the utilities provided by your webhost. For some, you can click the “Backup” feature icon in your control panel and click the link to the zencart database under “Download a MySQL Database Backup”.

Many webhost will have a utility called phpMyAdmin that you can use to backkup the database. As an example, here is how to backup the database using phpMyAdmin on Hostmonster.

1. Log into your hosting account and go into the Webhosting Control Panel.

2. Click on the item MySQL Databases.

3. Scroll down until you find an icon showing phpMyAdmin and click it.

4. Click “Databases”…

show databases

show databases

5. This will show you a list of databases on your host — perhaps there is only one. Click on your ZenCart database.

access the zencart database

access the zencart database

6. Click the Export tab.

 

export the zencart database

export the zencart database

7. Select all tables for export…

export all tables

export all tables

8. Checkmark Save As File and click Go.

save export to file

save export to file

9. Your browser will prompt you to save an SQL file.

save export to file

save export to file

10. Make note of the filename and save it to a save place. You can rename the filename (such a adding a date stamp) if you like.

 

This file contains a sequence of SQL commands that will rebuild your database should anything happen to it.

Using ZenCart backup plugin.

Alternatively, you can try installing and using the mysql backup plugin. It work for most (but no all) web hosts.  But when it does work, it makes backup a snap.

1. Once the plugin is installed, you can backup the database by logging into the admin panel -> Tools -> Database Backup MySQL.

zencart database backup

zencart database backup

2. Click the “backup” button…

zencart database backup manager

zencart database backup manager

Note that the backup file will be written to the file server in the backup directory indicated. Typically, in public_html/catalog/admin/backups. So if you want to pull the backup file down via FTP, you can get at it.

3. Select a compression option and click Backup. Note, if your webhost does not have GZIP available, you will not see that option. In that case, just select No Compression.

zencart backup options

zencart backup options

4. Look for a successful backup…

zencart backed up successfully

zencart backed up successfully

See that in the above picture, we have a backup file db_zencart-20070927210856.sql.gz created on 9/27/2007 at 21:08:57 located at /home/yourdomain/public_html/catalog/admin/backups/ directory on your webhost.

 

 


Related Posts

Tags

Share This