Basic tutorials 22.06.2013 backup, database, export, knowhow, mysql, phpmyadmin, tutorial

Prestashop database backup

Fast and easy way to make a prestashop database backup. This is most important step when you want, for example, move your store to another hosting.

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:

prestashop database export

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.

database export prestashop tutorial

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

database export settings prestashop phpmyadmin

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