Datensicherung: Difference between revisions

If you prefer a manual mode, you can also use the backup tool designed for your database.

With Mysql, the command to backup your database into a file is :

mysqldump -u user -pyourpass --result-file=mysqldump_databasename_version_date.sql databasename

where :

* ''user'' is MySQL user that Dolibarr use to connect to database,

If you want to have your file compressed (compressé) :

mysqldump databasename -h host -u user -pyourpass -l --single-transaction -K --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 | bzip2 > mysqldump_databasename_version_date.bz2

Dump file will be generated with a bzip compressed format.

With Linux, to make a regular backup at 1:30 each day into file mysqldump_databasename_DD.sql.bz2, you can add this into your cron file:

30 1 * * * mysqldump databasename -h host -u user -pyourpass -l --single-transaction -K --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 | bzip2 > mysqldump_databasename_`date +%d`.sql.bz2

=== Using phpMyAdmin ===

[[File:Warning.png]] in any case, '''your sql backup file should disable foreign keys prior to restoring''', else your backup won't be restorable because of foreign keys clashing!

Eg: Add FOREIGN_KEY_CHECKS in headers and footers:

-- SQL Dump

-- Server version: 5.5.8

SET FOREIGN_KEY_CHECKS=1;