Continuing in our Advanced Parameters course, we come to the Database Backup section. This section allows you create database backups and adjust the settings for importing them. Below are the instructions for how to perform these tasks in PrestaShop 1.5

Configuring the CSV Import in PrestaShop 1.5

  1. Log into your PrestaShop 1.5 dashboard.
  2. Using the top menu bar, hover over the Advanced Parameters tab and click on the DB Backup option from the menu.
  3. This brings you to the DB Backup page. Be sure to read the disclaimer before selecting the I have read the disclaimer - Create a new backup button. Click the button when ready to make the backup.
    db-backup
  4. Your backup should now appear in the lower section of the screen.
    dbbackup-adv-parameters
    The advanced parameters only consist of two settings.
    Ignore Statistics Tables Enabling this option will cause the backup to ignore the statistics tables when creating the backup.
    Drop Existing Tables During Import This option will cause the import to drop existing tables prior to importing the data from the backup file.
You are viewing Section 10: Creating a Database backup in PrestaShop 1.5
Section 9: Using CSV Import for Advanced Parameters in PrestaShop 1.5
Section 11: Downloading a Database backup in PrestaShop 1.5
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

2014-02-01 8:54 am
And can you automate this with a cron job? (if so which is that)
Staff
9,193 Points
2014-02-03 9:05 am
Technically, yes a cron job can be used to create a MySQL backup, however, I strongly recommend against it as backups will increase the server load and can cause issues if backups are run too often. The command that you would run would be the following:

mysqldump -u DBUSER -pPASSWORD DATABASENAME > FILENAME.sql



Of course, replace the user, password, database name, and filename in the above line with your information.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

2 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!