Database migration

Hello,
I’m moving Dolibarr from my computer to a remote server.
Where is the database? What files I have to migrate to have all the data like on my computer?

Thanks

Hi,
I’m not a specialist but I did the same kind of operation before (moving my doliwamp install to a web server), so maybe I can give you some clues.

Firstly you should make sure that your remote server already supports and is working fine with Apache, PHP and MySQL…

Then you take a look at the wiki http://wiki.dolibarr.org/index.php/Installation_-_Upgrade to choose which way to proceed on the installation according to your type of remote server.

Then you proceed on a fresh installation on your remote server.

On your local computer, you backup the local database using PhpMyAdmin (you’ll get a .sql file), then you save as well the whole content of the dolibarr documents folder.

Then with PhpMyAdmin, but on the remote server side, you delete the fresh database and create a new empty one with the same name, then you restore your local .sql backup file inside.

Still on the remote server side, you delete the content of the fresh dolibarr documents folder and copy the one you saved from your local computer.

You should be ready to open a browser and to connect to dolibarr on the remote server then to follow the instructions (anyway it should be an exact copy of all of the data from your local computer).

Hope it helps !

Assuming you are using: Doliwamp 11.0.4 for both
From your Computer log in to localhost/dolibarr username: admin password: yourpassword. Backup the Database MySQL or MariaDB and the c:\dolibarr\www\dolibar\htcdocs*.*

Log in to the remote server by using Remote Desktop Connection on Windows or Anydesk on Linux, you need to install Dolibarr with the same version you have on your PC. Create a folder and upload the backup you will make from your PC and the Docs.
You need to copy those docs back to c:\dolibarr\www\dolibarr\htcdocs and restore the back up. Thats all.