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
Artykuł napisany przez Milosza Myszczuka, eksperta PrestaShop i oficjalnego moderatora społeczności PrestaShop. CEO i założyciel agencji interaktywnej VEKIA. Dowiedz się więcej.
If you like this article, support our work!

The Currency Exchange Module offers unparalleled flexibility in managing international sales. Regard...
19.99 €

Automatic National Bank of Ukraine (NBU) currency rates integrator. The module guarantees precise pr...
19.99 €

Automatic Bank of Spain (Banco de España - BdE) currency rates integrator. The module guarant...
19.99 €

Streamline your order fulfillment process with the Order PDF Export module for PrestaShop. This esse...
39.99 €