The advantage when you backup your MySQL:

upgrade your site
load a new csv file
errors with your server

Backing Up Your MySQL Database

1. Firstly , you need to login to cpanel and scroll to the bottom and look for the phpMyadmin

2. Click on a database or table in the left frame and click data which you want to backup

3. In the top menu , you click on export icon

4. After you click export , it will ask you that you want to do a quick export or a custom export. At prestashop 1.6.1.0 version, databases can get large ,you need select custom and press Go

Note : You should use gzip as the compression format as it is universally supported.

5. Finally , you press Ok button and your database will start to download

Congratulations! You have just created a backup of your MySQL database!

July 8, 2015 Tutorials

About the author

Apollo Theme is the most modern provider of Shopify Template. With 9 years experience, we bring many modern and perfect themes to everyone. With the aim of providing high-quality products for customers, our talented team always tries to work hard and catch up the new trend of technology and design to give you more valued template with a unique combination of new ideas, flexible architecture and easy-to-use product. We are really appreciated it and hope that you enjoy it! Apollo Template want bring the highest customer satisfaction, we have professional supporting team to assist all our buyer. All support will be conducted through our support ticket "https://apollotheme.com/ticket/", send your problems to our email: "apollotheme@gmail.com" or at our facebook with name “Apollo Theme”. We usually get back to you within 24hours. (except holiday seasons which might take longer).