Migrating data between 2 CRM

Using my Dolibarr CRM/SRM Modules
1

Hello,
Our CRM is hosted on Hostgator, and we got a new Hostgator account with new web address. And we want to have exactly same CRM in our new Hostgator, how do we migrate the all of the data we have to new CRM? I check the document in this forum but MySQL DUmp in CRM Admin tools giving an error.
Error : Failed to run external command. Check it is available and runnable by your PHP server user. Check also the command is not protected on shell level by a security layer like apparmor.

2

You might try the other dump function:

IMG_8720
IMG_87201125×2436 270 KB

3

Hello,

You can backup database from phpmyadmin : https://www.hostgator.com/help/article/phpmyadmin
Or use the backup function : https://www.hostgator.com/help/article/how-to-download-and-restore-a-mysql-database-backup

4

I encountered a similar issue where running the database backup command failed with the following error:

“Failed to run external command. Check it is available and runnable by your PHP server user. Check also the command is not protected on shell level by a security layer like AppArmor.”

Observations

  • The command to run the backup differs between two servers: one where it works and another where it doesn’t.
  • The issue may be related to how the database was exported. I used phpMyAdmin on Hostinger’s shared hosting to export the database and later imported it into a server managed by CloudPanel. This is when the error started appearing.
  • However, after performing a fresh installation of the application on the same CloudPanel server and running the database backup command, it worked without any issues.

Comparison of Commands

Here are the differences in the commands between the working and non-working setups:

Command on Working Server:

/usr/bin/mysqldump dolibarr -h localhost -u doliuser --single-transaction --quick --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 --no-tablespaces -p"********************"

Command on Non-Working Server:

/srv/mariadb12345/usr/bin/mysqldump dolibarr -h localhost -u doliuser --single-transaction --quick --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 --no-tablespaces -p"********************"