Zen Cart is one of the most efficient free open source eCommerce shopping cart software, that is widely used by the online store websites. Zen Cart has the unique feature of simplifying the online shopping procedure for both, the customers and also the business owners.
Zen Cart has a user friendly interface therefor it is easy to install and setup by any person who is not technically qualified. You will come across a wide range of free and open source shopping carts that can be downloaded and installed, however Zen Cart stands apart in terms of the features offered. Zen Cart is known as the art of eCommerce that alleviates the functionality of an eCommerce website.
In some cases the website hosting company performs the complete server backup instead of the selected databases you want. Sometimes restoring a particular database might not be possible from the full server backup. Therefore it is always preferable to know how to backup and restore Zen Cart MySQL Database on your dedicated server. The following two methods can be used for backing up and restoring your Zen Cart Database:
* Backup and Restore Database using phpMyAdmin
* Backup and Restore Database using Database Backup – MySQL Plugin
This post will illustrate the process of backing up and restoring Zen Cart MySQL Database using both the methods. Here is detailed information on both these methods:
Backup Zen Cart MySQL Database using phpMyAdmin
phpMyAdmin is one of the most popular and efficient tools available in cPanel for managing the MySQL databases. Usually, it is installed as default in the cPanel by every website hosting provider. In case it is not 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 most convenient ways 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 click on the Zen Cart database
Step 3 : A screen will be displayed showing you the tables available inside your Zen
Cart store database. Ignore those and click on the ‘Export’ tab that is present on top of all the tables
Step 4: Select your Zen Cart files shown in the ‘Export’ box starting with the ‘zen_’ or ‘Select All’ in order to select all the files present by default
Step 5: Under that export box make sure you select the ‘SQL’ for downloading the backup file in .sql format
Step 6: Under the ‘SQL options’ make sure that the following settings are clicked.
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 and click on ‘Save as file’ option and do not make any changes to the file name template
Step 8 : Select the compression method “gzipped”
Step 9 : Click on the ‘Go’ button and and save the file on your local machine
The process of backing up the database using phpMyAdmin is now complete, now lets look at the process of restoring a backup using phpMyAdmin.
The process of restoring a Zen Cart MySQL database backup using phpMyAdmin is mentioned below assuming that you have logged into cPanel >> phpMyAdmin
Step 1: Click on the Zen Cart databade present on the left panel
Step 2 : Click on the ‘Import’ tab present on the top of the tables
Step 3 : In order 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 : Click on the ‘Go’ button
After the completion of these steps 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 that is available in the Zen Cart eCommerce hosting shopping cart Admin panel that enables fast backup and restore of databases from the Admin Panel of your Zen Cart. Now lets look at the process of backing up 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 then click the ‘Database Backup – MySQL’ option
Step 3 : Click on the ‘Backup’ button to backup your Zen Cart database
Step 4 : You will have to select the file compression method present on the right side panel. Selecting the GZIP compression is recommended 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, you can tick on the Download button without ‘storing on server’ option. If that option is unchecked, the file will be saved to the server in the admin backups directory. If you want to download it from the server, you can do this by downloading a copy of it through the FTP client
Step 6 : Now, click on the ‘Backup’ button to proceed
After the completion of this process, 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 the FTP client
Step 2 : Login to your Admin Panel of Zen Cart Store
Step 3 : Now, click on the ‘Tools’ menu, in order to navigate to ‘Database Backup – MySQL’ option and click on it
Step 4 : Select the backup file that you wish to restore from the list of the backup files
Step 5 : Now click on the ‘Restore’ button on the right side bar. Make sure that you click on the Restore button present on the right side and not the button under the backup files list
This completes the process of restoration of the Zen Cart backup file.