This article is part of our Guest Blogger Series. Its content was created by Lesley Paone, a PrestaShop Global Forum Moderator (Dh42) and the owner of Nashville-based Designhaus 42.

How to Manually Back-Up MySQL Database

Have you ever wanted to know how to manually back up your Prestashop store? This can be really useful if you are going to upgrade your site, load a new csv file, or just to have in case anything happens to your server. Backing everything up manually is a great idea, most developers do it. Below I will show you how.

 Backing up the database

The first step is to back up the database. For this you are going to need to login to the cpanel for your site. Normally they are located at either or When you access it you will see this screen.

From that screen you can login to your cpanel. Usually your cpanel login is the same as your ftp login, but that is not always the case. If you are unsure of your login refer to the email your host set up when you created your account or email them and ask them for the login information. Once you are logged in, you want to scroll to the bottom and look for the phpMyAdmin icon. It is under the headings databases.


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.


When you click on your database it will open up in a view that shows all of the tables in your database. From that view click on export in the top menu, like the image below.


 Once you click on export the next screen will ask you if you want to do a quick export or a custom export. Due to the size limitations of hosts and that Prestashop 1.5 databases can get large, select custom and press ok.


The only thing you really need to select during the custom export is the compression. I recommend using gzip as the compression format, as it is universally supported.


Now press Ok at the bottom of the screen and your database will start to download.

Now you have a complete backup of your Prestashop 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.


How to Manually Back-Up PrestaShop Files via FTP

What happens to your site if your server crashes? You could lose all of your and it might take months to rebuild your store again. Never fear, I will show you how you can back up your files manually in case anything happens. I would also suggest using this in conjunction with our article on manually backing up your database.

Downloading your site

First things first, you are going to need the ftp information to log into your site. When you signed up for your web hosting you should have received an email with all of this information in it. You are also going to need an ftp program, I recommend Filezilla, it is the most popular these days. Once you have it installed, open it up, it should look like this.

As you can see in the image above I have highlighted where you will enter your server information. Once you have it entered you can click quick connect. Normally you will not have to enter anything for the port number, you can leave that blank.


Once you are logged in, depending on how your host is set up, it should look like the image below. All you have to do to back up your site is to right click on the public_html directory in the left pane and select download. If your site is very large this could take several hours.

The only time that your files will ever need to be backed up again is if you

  • Add new products to your site
  • Install or remove any modules
  • Install another template
  • Edit your existing template
  • Upgrade your shop
  • Or if you make any changes to core files

People placing orders or contacting your customer service will not affect the files on your site, all of that information is installed in the database. So if you never do any of the above mentioned things you will only have to back your site up once, which is awesome.


Receive articles like this in your inbox!

Subscribe to get the latest ecommerce news and tips sent directly to your email. Subscribe

ShareTweet about this on TwitterShare on Facebook0Share on LinkedIn5Share on Google+7

See the 12 Comments

Comments (12)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>