Zen Cart is a free open source eCommerce shopping cart software, which is widely used by online stores. Most of the shopping carts seems to be built with much complicated programming, but Zen Cart is the one who puts the merchants and customers needs at the first place. It is an eCommerce software, easy to install and setup by any non-technically skilled person that has basic knowledge of computer.
There are many free and open source shopping carts available to download and install, but none can compare with the features and support Zen Cart offers.
Depending on your web hosting provider for backing up your Zen Cart store database is not always good. The backup and restore of your databases done by the Web Hosting UK company will benefit only them, not you. Usually, the web hosts will perform the full server backup instead of the selected databases you want. You cannot ask them to restore a particular database from the full server backup, its kind of tricky and may not accept your request.
Hence, it is always better to know how to backup and restore Zen Cart MySQL Database on your dedicated server hosting server by your own. Backing up and restoring your Zen Cart Database can be done using the following two different methods:
- Backup and Restore Database using phpMyAdmin
- Backup and Restore Database using Database Backup – MySQL Plugin
In this article, we will show you how to backup and restore Zen Cart MySQL Database using both the methods. Let’s start with the first method.
Backup Zen Cart MySQL Database using phpMyAdmin
phpMyAdmin is one of the widely used and popular tool available in the cPanel to manage MySQL databases. Usually, it is installed default into cPanel and offered by almost every web hosting provider. If it is not installed on your dedicated server, you can ask your web host to install it on your dedicated server. This is one of the best and easiest way to backup and restore specific MySQL database tables.
Step 1: Login to your cPanel control panel and click on phpMyAdmin.
Step 2: Now, on the left panel click on the Zen Cart database.
Step 3: A screen will appear showing you the tables available inside your Zen Cart store database. Forget those, and simply click on the “Export” tab on the top of the tables.
Step 4: Select your Zen Cart files shown in the “Export” box starting with the “zen_” or “Select All” to select all the files by default.
Step 5: Under that export box make sure you select the “SQL” to download your backup file in .sql format.
Step 6: Under the “SQL options“ make sure you tick the following settings.
a) Add DROP TABLE
b) Add AUTO_INCREMENT value
c) Enclose table and field names with backquotes
a) Complete inserts
b) Extended inserts
c) Use hexadecimal for BLOB
Step 7: Select the box “Save as file” option and don’t make any changes to the file name template.
Step 8: Select the compression method “gzipped”.
Step 9: Hit the “Go” button and save the fie to your local machine.
That’s it! Now, you know how to backup database using phpMyAdmin, let’s learn how to restore a backup using phpMyAdmin.
Restore Zen Cart MySQL database backup using phpMyAdmin
We totally assume that you have logged into your cPanel >> phpMyAdmin.
Step 1: On the left panel, click on the Zen Cart database.
Step 2: Click on the “Import” tab on the top of the tables.
Step 3: To select the database backup file from your local machine, click on the “Choose File” button and select the backup file you want to restore.
Step 4: Hit the “Go” button.
That’s it! Your Zen Cart database backup fill will be uploaded to the server and restored successfully.
Backup Zen Cart Database using Database Backup – MySQL Plugin
Database Backup – MySQL plugin is a module available in the Zen Cart eCommerce Hosting shopping cart Admin panel that allows fast backups and restores of databases from within the Admin Panel of your Zen Cart. Let’s see, how to backup your Zen Cart database using the database backup – MySQL plugin.
Step 1: Login to your Zen Cart Admin Panel.
Step 2: Now, click on the “Tools” menu and click the “Database Backup – MySQL” option.
Step 3: Hit the “Backup” button to backup your Zen Cart database.
Step 4: On the right side panel, you will need to select the file compression method. We recommend you to select the GZIP compression as it will reduce the size of your backup file.
Step 5: You can download the backup file directly to your local machine without storing it on the server. If yes, tick the Download without storing on server” option. If don’t, unchecked it, and the file will be saved to the server in the admin backups directory. If you wish to download it from the server, you can always download a copy of it using your favorite FTP client.
Step 6: Now, hit the “Backup” button to proceed.
That’s it! You will receive a message to the Top Left Corner “Success: The database has been saved.”
Restore Zen Cart Backup File using Database Backup – MySQL Plugin
Step 1: In order to restore the backup file stored on your local machine, you need to put it in the /admin/backups/ directory on your server using favorite FTP client.
Step 2: Login to your Admin Panel of Zen Cart Store.
Step 3: Now, click on the “Tools” menu, navigate to “Database Backup – MySQL” option and click on it.
Step 4: Choose the backup file you wish to restore from the list of the backup files.
Step 5: Simply click on the “Restore” button on the right side bar. Make sure you click the Restore button on the right side and not the button under the backup files list.
That’s it! The restoration of the Zen Cart backup file will be done successfully.
Like this post ?
Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers.
Email us the shared link at : [email protected] or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand side of this page and we will provide you with the discount Coupon right away!