Backup Your Database Using PHPMyAdmin



If you aren’t already backing up your database regularly, you should be! Having a good, recent backup of your database will allow you to get your zen cart store up and running again quickly in case anything goes wrong. This step by step tutorial will show you how to backup your database using PHPMyAdmin.

1. Log into your web hosting account. Open your phpMyAdmin.

phpmyadmin Easy Help Zen Cart Tutorial™:  How to Backup Your Zen Cart

Select the database for your zen cart store. Click on “Export”.

phpmyadmin 5 Easy Help Zen Cart Tutorial™:  How to Backup Your Zen Cart

Under options, make sure these recommended settings are selected:

  • Structure
  • Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
  • Add IF NOT EXISTS
  • Add AUTO_INCREMENT value
  • Enclose table and field names with backquotes
  • Add CREATE PROCEDURE / FUNCTION / EVENT

And:

  • Data
  • Complete inserts
  • Use hexadecimal for BLOB
  • Export type must be set to INSERT

phpmyadmin 4 Easy Help Zen Cart Tutorial™:  How to Backup Your Zen Cart

Check “Save as file” and click on “Go”.

phpmyadmin 6 Easy Help Zen Cart Tutorial™:  How to Backup Your Zen Cart

Save the file to your computer.

It is a good habit to back up your database on a weekly basis.

If you need help customizing your zen cart web site, or would like a great custom design, please contact us for a quote.

equation

Article Global Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Eli Pets