Creating a Database backup in PrestaShop 1.5
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
- Log into your PrestaShop 1.5 dashboard.
- Using the top menu bar, hover over the Advanced Parameters tab and click on the DB Backup option from the menu.
- 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.
- Your backup should now appear in the lower section of the screen.
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.
We value your feedback!
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.
2014-02-01 8:54 am
And can you automate this with a cron job? (if so which is that)
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.