Migrate To DoliCloud
From Dolibarr Wiki
I use Dolibarr onto another server. How can I migrate to DoliCloud (Dolibarr hosting service in the Cloud) ?
This description works for every users using a MySql database.
You can execute all the migrate process yourself following this tutorial. However, if you need more help, you can ask questions to email@example.com (support is free, even with the Basic Plan for any migration/setup questions).
- Check that you Dolibarr version (you will find it onto logon page) is lower or equals to DoliCloud version (In most cases, it should be true because DoliCloud plan offers the last stable version).
If your local version is older, it is better to upgrade first locally to same version than DoliCloud, but not necessarily. Upgrade process can be done after migration to DoliCloud (see later).
Step 1 - Backup your old database
- First step is to backup your database.
For this, go into menu Home - System tools - Backup. Click to generate a backup file (with mysqldump method). This will launch mysqldump command and show you the command. If you experience problem running this command (for example because your old hosting provider does not allow to run command mysqldump), you can launch the command from any other computer where MySql is installed. For this, run the following command:
mysqldump -h ip_of_old_mysql_server -P port_of_old_mysql_server -u user_database -ppassword_database > myoldserverdump.YYYYMMDD.sql
- Open file myoldserverdump.YYYYMMDD.sql to see if file is complete: File should end with such a line:
-- Dump completed on YYYY-MM-DD HH:mm:ss
Step 2 - Copy content of your document files
All uploaded or generated files are stored into the document directory. To know path of this directory, go into menu Home - System info - Dolibarr - All parameters. Full path where all you files are stored is visible on line with key dolibarr_main_data_root. Save this directory and all its content (subdirectories and files).
Step 3 - Create a DoliCloud instance
Go onto http://www.dolicloud.com and subscribe to create a new instance. Note that creating an instance is free for 15 days.
Step 4 - Upload documents into DoliCloud
Once instance is created, you receive a mail with id to log to Dolibarr and to log to your dashboard.
- First, log to your new Dolibarr instance. Go into menu Home - System info - Dolibarr - All parameters. You will find on line for key dolibarr_main_data_root, the value of full path of directory where documents are stored on DoliCloud instance.
- Then log to your new DoliCloud dashboard. You will find an area with your SFTP credentials identifiers.
With any SFTP software (WinSCP or FileZilla for Windows, Nautilus for most Linux), login to DoliCloud using SFTP protocol and thoose credentials. Copy all documents files and sub-directories you saved from previous step into the DoliCloud document directory.
Step 5 - Load your old database
- Log to your new DoliCloud dashboard again. You will find an area with your Mysql identifiers.
Go on any computer where MySql and mysqldump command is install. Launch the following command to save the new DoliCloud initialized database (to restore DoliCloud if something is wrong later).
mysqldump -h yourinstance.on.dolicloud.com -P 3306 -u doliclouduser -pdolicloudpassword -Ddoliclouddatabase > dolicloud.YYYYMMDD.sql
where all information yourinstance.on.dolicloud.com ,doliclouduser, dolicloudpassword and doliclouddatabase can be found onto your DoliCloud dashboard.
- Run the following command to overwrite database with database of your old server.
mysql -h yourinstance.on.dolicloud.com -P 3306 -D doliclouddatabase -u doliclouduser -pdolicloudpassword < myoldserverdump.YYYYMMDD.sql
Now, call your Dolibarr login page into DoliCloud.
If your old Dolibarr version was older than DoliCloud Dolibarr version, you should receive a page to ask you to launch the upgrade process. Just choose the choice suggested by the upgrade wizard. If you receive a message saying upgrade is "locked" be file install.lock, launch again your SFTP client and remove the file documents/install.lock.
Once upgrade is done, or if your version was same than DoliCloud, you can connect using a user that did exists into old server database, with same password. Your admin user created during DoliCloud init does no more exists as it was overwritten by the database load at previous step.