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