Today i want to write something about Database Backup. It is really worth to know how to do that and of course you should make a data & database backup as often as possible. Before each configratin change (like back office settings) in a store, it is worth to do a database backup. So, you can read about whole process below.
What you need?
The most important tool for database backup is the PHPMyAdmin software installed on your hosting. It's usually available and you - as a shared hosting owner have got possibility to use it.
Database Backup
Log in to your PHPMyAdmin account, and from the left hand side databases list - select database related to your prestashop store:

Then - in the windown on the right and side you will see all available tables - and settings related to the database you selected. Click on "export" button.

After clickng on "Export" you will see export settings page:

Select "Quick" as export method, SQL as database format and click on "Go" button. After that your database will be downloading. File that you download - this is your FULL database backup.
You can also read next article related to this: How to import prestashop database
Article written byMilosz Myszczuk, PrestaShop expert. CEO and founder of the VEKIA interactive agency. Learn more.
If you like this article, support our work!

Omnibus Directive Pro module for PrestaShop. It records price history and displays the lowest 30-day...
39.99 €

Free PrestaShop addon for EU Omnibus compliance. It automatically records price history and shows th...

Keep “Add to cart” visible on long product pages! Sticky Cart Bar FREE shows a slim, sticky stri...

Free Shipping Progress Bar is a free PrestaShop module: show shoppers how much is left for free deli...