LiveChat 
Support 
Backup and Restore Zen Cart Database on Dedicated Server
Zen Cart could be a free open source eCommerce shopping cart package, that is widely utilized by on-line stores. Most of the shopping carts appears to be designed with abundant complicated programming, however Zen Cart is that the one who puts the merchants and customers needs at the top place. it’s associate eCommerce software, easy to install and setup by any non-technically skillful individual that has knowledge of computer.
There are several free and open source shopping carts available to download and install, however none will compare with the options and support Zen Cart offers.
Depending on your web hosting supplier for backing up your Zen Cart store database isn’t always good. The backup and restore of your databases done by the web Hosting UK company can profit only them, not you. Usually, the web hosts can perform the total server backup rather than the chosen databases you wish. you can not ask them to restore a specific database from the full server backup, its quite difficult and will not accept for your request.
Hence, it’s perpetually 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 is done using the following two different methods:
Using phpMyAdmin, Backup and Restore Database
Using Database Backup – MySQL Plugin, Backup and Restore Database
In this tutorial, we are going to show you how to backup and restore Zen Cart MySQL Database using both the methods. Let’s see the first method.
using phpMyAdmin ,Backup Zen Cart MySQL Database
phpMyAdmin is one amongst the widely used and popular tool available within the cPanel to manage MySQL databases. Usually, it’s installed default into cPanel and offered by virtually each web hosting provider. If it’s not installed on your dedicated server, you’ll be able to ask your web host to install it on your dedicated server. This is often one amongst the best and easiest way to backup and restore specific MySQL database tables.
Step 1: Firstly you have to Login to your cPanel control panel and then 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.
1) Structure:
a) Add DROP TABLE
b) Add AUTO_INCREMENT value
c) Enclose table and field names with backquotes
2) Data:
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 all! Thus, now you will come to know how to backup database using phpMyAdmin, let’s see how to restore a backup using phpMyAdmin.
Using phpMyAdmin, Restore Zen Cart MySQL database backup
We fully assume that you have been 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 how it is! Your Zen Cart database backup fill can 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.