• Lesson Index:
• Overview
• Yahoo Stores
• Signing Up
• Granting FTP access
• Granting Store Access
• Security Key
• Yahoo ID Password
• Using PayPal
• Changing PayPal
• YStore UPS Tools
• Process Orders
• Yahoo Store Notes
• ZenCart for Merchants
• Open Close Store
• Update Products
• Customer Welcome
• Order Confirmation
• Fulfilling Orders
• Statistics Reports
• Database Backup
• Backup Plugin
• Clean Admin Log
• Tasklist Summary
• ZenCart for Developers
• Sideboxes and EZ Pages
• Editing EZ Pages
• Template Overrides
• Suggestive Sell
• Graphical CSS Buttons
• Configure Shipping
• Sales Tax
• Installing PayPal IPN
• Email Notifications
• Patching ZenCart
• ZenCart Notes

Alternatively, you can try installing and using the mysql backup plugin. It doesn't work for all web hosts, but when it does, 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.

2. Click the "Backup" button

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.

4. Look for a successful backup...

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. Just select that file and click the restore button if you ever need to restore that particular backup.

Next Lesson: