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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
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:<\/p>\n
Using phpMyAdmin, Backup and Restore Database<\/strong><\/p>\n Using Database Backup \u2013 MySQL Plugin, Backup and Restore Database<\/strong><\/p>\n In this tutorial, we are going to show you how to backup and restore Zen Cart MySQL Database using both the methods. Let\u2019s see the first method.<\/p>\n 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.<\/p>\n Step 1:<\/strong> Firstly you have to Login to your cPanel control panel and then click on phpMyAdmin.<\/p>\n Step 2:<\/strong> Now, on the left panel click on the Zen Cart database.<\/p>\n Step 3:<\/strong> A screen will appear showing you the tables available inside your Zen Cart store database. Forget those, and simply click on the \u201cExport\u201d tab on the top of the tables.<\/p>\n Step 4:<\/strong> Select your Zen Cart files shown in the \u201cExport\u201d box starting with the \u201czen_\u201d or \u201cSelect All\u201d to select all the files by default.<\/p>\n Step 5:<\/strong> Under that export box make sure you select the \u201cSQL\u201d to download your backup file in .sql format.<\/p>\n Step 6:<\/strong> Under the \u201cSQL options\u201c make sure you tick the following settings.<\/p>\n 1) Structure:<\/strong><\/p>\n a) Add DROP TABLE 2) Data:<\/strong><\/p>\n a) Complete inserts Step 7:<\/strong> Select the box \u201cSave as file\u201d option and don\u2019t make any changes to the file name template.<\/p>\n Step 8:<\/strong> Select the compression method \u201cgzipped\u201d.<\/p>\n Step 9:<\/strong> Hit the \u201cGo\u201d button and save the fie to your local machine.<\/p>\n That\u2019s all! Thus, now you will come to know how to backup database using phpMyAdmin, let\u2019s see how to restore a backup using phpMyAdmin.<\/p>\n We fully assume that you have been logged into your cPanel >> phpMyAdmin.<\/p>\n Step 1:<\/strong> On the left panel, click on the Zen Cart database.<\/p>\n Step 2:<\/strong> Click on the \u201cImport\u201d tab on the top of the tables.<\/p>\n Step 3:<\/strong> To select the database backup file from your local machine, click on the \u201cChoose File\u201d button and select the backup file you want to restore.<\/p>\n Step 4:<\/strong> Hit the \u201cGo\u201d button.<\/p>\n That\u2019s how it is! Your Zen Cart database backup fill can be uploaded to the server and restored successfully.<\/p>\n Database Backup \u2013 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\u2019s see, how to backup your Zen Cart database using the database backup \u2013 MySQL plugin.<\/p>\n Step 1:<\/strong> Login to your Zen Cart Admin Panel.<\/p>\n Step 2:<\/strong> Now, click on the \u201cTools\u201d menu and click the \u201cDatabase Backup \u2013 MySQL\u201d option.<\/p>\n Step 3:<\/strong> Hit the \u201cBackup\u201d button to backup your Zen Cart database.<\/p>\n Step 4:<\/strong> 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.<\/p>\n Step 5:<\/strong> 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\u201d option. If don\u2019t, 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.<\/p>\n Step 6:<\/strong> Now, hit the \u201cBackup\u201d button to proceed.<\/p>\n That\u2019s it! You will receive a message to the Top Left Corner \u201cSuccess: The database has been saved.\u201d<\/p>\n Step 1:<\/strong> 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.<\/p>\n Step 2:<\/strong> Login to your Admin Panel of Zen Cart Store.<\/p>\n Step 3:<\/strong> Now, click on the \u201cTools\u201d menu, navigate to \u201cDatabase Backup \u2013 MySQL\u201d option and click on it.<\/p>\n Step 4:<\/strong> Choose the backup file you wish to restore from the list of the backup files.<\/p>\n Step 5:<\/strong> Simply click on the \u201cRestore\u201d 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.<\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-461","post","type-post","status-publish","format-standard","hentry","category-dedicated-server"],"yoast_head":"\nusing phpMyAdmin ,Backup Zen Cart MySQL Database<\/h3>\n
\nb) Add AUTO_INCREMENT value
\nc) Enclose table and field names with backquotes<\/p>\n
\nb) Extended inserts
\nc) Use hexadecimal for BLOB<\/p>\nUsing phpMyAdmin, Restore Zen Cart MySQL database backup<\/h3>\n
Backup Zen Cart Database using Database Backup \u2013 MySQL Plugin<\/h3>\n
Restore Zen Cart Backup File using Database Backup \u2013 MySQL Plugin<\/h3>\n