Backups
Why ?
There is several reason why it is important to "backup" a complete instance of Dolibarr. For example:
- Because you plan to make an upgrade and want to do a go back to previous version if it fails.
- Because you want to move Dolibarr from one server to another server.
- And of course, to be able to make a restore to be safe if something bad happens (crash disk, hack corruption, ...)
For all the above reasons, it is recommended to regularly make a new backup of all data used and saved by Dolibarr.
What to save ?
Dolibarr save its data in 3 different spaces. They all must be saved before each version upgrade to be sure to be able to get back its data if a problem occurs or if you want to go back on previous version. This is the 3 kind of data you need to save to be sure to loose nothing.
The configuration file
The configuration file should not be modified by upgrade process, but it is more prudent to save it also when you do an upgrade. The configuration file is called conf.php and you can find it into directory dolibarrdir/htdocs/conf/. Make a copy of this file into the dedicated area of your backup.
Note: This backup is however optional as you can still rebuild this file manually from scratch or with the Dolibarr install wizard if you know your database credentials (this file contains only parameters to connect to database and directory where you Dolibarr is installed). When making a restore, it is still possible to rebuild this file by an installation from scratch.
The database
The database contains all data you have added from Dolibarr screens (except the attached/generated files that are presented in next chapter). Saving the database must be done in a global way (all content). It is advised to save the database regularly. See the chapter "How" later in this document.
Documents
All documents related to your Dolibarr instance are saved into directory defined into your config file dolibarrdir/htdocs/conf/conf.php. If you kept the choice by default during first installation, it should be something like dolibarrdir/documents. This directory must be completely saved. When making an upgrade, the upgrade process should not change this directory, however this directory can be read and write by web server at any time, it might be altered by a bad action or a bug. To be sure to keep all your joined files and be able to restore them if they are accidentally deleted or altered, just make a copy of all content of this directory.
Note: copying the whole folder containing all your documents might be an heavy process, so if you can't do this regularly, at least make a backup of your database (which should be a lot smaller and would still enable you to recover most of your data, which can then be used to regenerate most of your documents).
Code change
Finally, any custom development of modules, ie: all php files (or others) that would have been added or modified to accommodate specific needs, should also be saved. In most cases, you are not concerned by this point.
When ?
Frequency of backups depends on how often you use Dolibarr and what you accept to loose if something happens. More often the frequency, less data will be lost in case of a crash/failure.
Also, you can choose to backup more often one part (like the database) that is more critical, and less regularly others because they are more heavy (like the documents).
As a good starting point, you database should be backed every 1 month or even every 1 week depending on your usage, while documents can be backed every 6 months or every 1 month depending on your usage once again.
Also, the conf.php file needs to be backed only once (since it only changes if you change your host, and anyway can be made manually).
How ?
The configuration file
A simple copy of file conf/conf.php into a directory dedicated to your backup is enough.
The database
There are 4 ways to backup your database:
Dolibarr's system tools backup
This is the simplest way to make your backup, and in addition all your backups will be stored on server and will be listed, so that you can retrieve any version anyday.
If you use a recent enough version of Dolibarr, just log into Dolibarr with an administrator account (only admins can use system tools).
Then go to Home -> System tools -> Backups. Choose your options for your backup (you can keep all default values).
Alternative: the default method MySQL Dump (mysqldump) also needs that you have access to the mysqldump binary in execution on your server. If you are on a shared host that disable this access, you can try another method by setting MAIN_FEATURES_LEVEL=1, and then a new method MySQL Dump (php) will appear. This method is still experimental, so please try it first by yourself by making a backup and then restoring it on a local, non production server to check that your data is correctly saved.
mysqldump
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=dolibarr.version.date.sql databasename
where :
- user is MySQL user that Dolibarr use to connect to database,
- yourpass is password of MySQL account user (warning, no space between the p and yourpass),
- databasename is the name of Dolibarr database.
Those informations (user, password and database) are available into your configuration file dolibarrdir/htdocs/conf/conf.php
The result file ("dump file"), is called dolibarr.version.date.sql where
- version is the dolibarr version (ex: 3.2).
- date can be replaced with a date, recommanded format is YYYYMMDD, with YYYY the year (ex. 2011), MM is month number (ex. 05) and DD is day in month (ex. 18).
With value used as example, we will get a dump file called dolibarr.3.2.20110518.sql.
phpMyAdmin
You can also use phpMyAdmin to save your database, but you must enable one specific option for you to be able to restore your backup later on (if you forgot to do so and already have a backup that you want to restore, please read the note about FOREIGN_KEY_CHECKS below).
In phpMyAdmin, click on the tab Export, then select your Dolibarr's database/tables (depending whether you are in multi-database view or tables view), and then enable the option Disable foreign key checks, also check that the output will be SQL, and then you can validate your export.
Third-Party Tools
You can also use third-party database backup softwares, like php scripts that you can upload on your server (such as db2SQL by Howard Yeend or BigDump), or also use database designer/workbench softwares which generally offer to remotely connect to your database and allow you to make a full backup (along to remotely manage your database).
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=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `llx_accountingaccount` (
INSERT INTO ...
CREATE TABLE ...
INSERT INTO ...
...
SET FOREIGN_KEY_CHECKS=1;
Mysqldump is the most secure way to backup your data because it is developped along MySQL and thus is always up-to-date. PhpMyAdmin and other thirdparty tools may generate a correct SQL dump but may be outdated or miss some features (depending on options you choose).
The documents
Just copy the Documents folder (dolibarr/documents by default) to your local backup directory.
Note: If you made a backup of the database with the System Tools of Dolibarr, the sql dump files also resides in the Documents folder, and thus will be copied along.
Restore
This topic is explained into page Restores.