'' Prestashop tutorial : how to backup Prestashop database 2023 '' ''

Prestashop Tutorial - How to backup Prestashop database

It is strongly recommended that you backup the database at regular intervals and before an upgrade.

NOTE: This Prestashop tutorial will show you how to backup your Prestashop database that include all your products, cms, manufactures and others, but DO NOT backup the files and folders such as images, theme files on the server.
If you need a complete Prestashop module to backup your database and files, i recommend you to use SOO Prestashop Cloud Backup.

Prestashop tutorial : Prestashop Backup

What you need?

The most important tool for database backup on this Prestashop tutorial 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.

Step by step to backup Prestashop database

First, log in to your PHPMyAdmin account, click on that icon and your database management will open up and look like the image below. Click on the database that you want to backup from the left column.

Prestashop Database on PhpMyadmin

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 :

Prestashop Table List

After click 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 :

Export Prestashop Database

Now you have a complete backup of your ecommerce database. So if anything happens to your site, you will be able to reload the database and restore it from when you last downloaded it. It is strongly recommended that you schedule to backup your ecommerce database everyday. SOO Prestashop Cloud Backup is my favourite module to set up automatic & scheduled backups for both files and database. You should to try it :)

iConvert Promotion

Learn more

Latest modules update!

ChargeMe v5.3.9 ⊙
Fix the backend issue.

Age Restriction - 18+ v2.3.4⊙
Fix the Smarty issues.

Newsletter Popup v3.2.1 ⊙
Fixed JS issues.

Trusty v1.4.7 ⊙
Compatible with both PrestaShop 1.7 & PrestaShop 8.

PrestaSOO team
Everything you need to make a living doing work you love.


It is a wise investment

PrestaShop modules we created first to solve the problem of our own business - an e-Commerce site. That means they are very useful for serious business. If you value your web property, these modules are a wise investment.
Sarah Reeves, App Developer @ PrestaSOO
Made with in Paris & Hanoi
PrestaSOO © 2023. All rights reserved. // Privacy Policy Terms of Service