30,909
edits
Migrate my Dolibarr To the Cloud: Difference between revisions
Jump to navigation
Jump to search
→If you have technical knowledge in Mysql database management software
mNo edit summary |
|||
| Line 82: | Line 82: | ||
mysql -h yourinstance.on.dolicloud.com -P 3306 -D doliclouddatabase -u doliclouduser -pdolicloudpassword < myoldserverdump.YYYYMMDD.sql | mysql -h yourinstance.on.dolicloud.com -P 3306 -D doliclouddatabase -u doliclouduser -pdolicloudpassword < myoldserverdump.YYYYMMDD.sql | ||
</source> | </source> | ||
[[Image:Warning.png]] Note: If you get an error like ''"ERROR 1005 (HY000) at line 25: Can't create table `...`.`llx_accounting_account` (errno: 150 "Foreign key constraint is incorrectly formed")"'', remove/drop manually the | |||
4 following table if they exists: llx_accounting_account, llx_accounting_system, llx_accountingaccount, llx_accountingsystem. Then try again. | |||
[[Image:Warning.png]] Note: If you get an error like ''"ERROR 1064 (42000) at line 18: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=InnoDb...' at line ..."'', replace the strings "TYPE=InnoDB" with "ENGINE=InnoDb" into dump file. Then try again. | |||
= Test = | = Test = | ||