30,909
edits
Migrate my Dolibarr To the Cloud: Difference between revisions
Jump to navigation
Jump to search
m
→If you have technical knowledge in Mysql database management software
mNo edit summary Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 94: | Line 94: | ||
[[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. | [[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. | ||
[[Image:Warning.png]] Note: If you get an error like ''"ERROR 1419 (HY000) at line 5616: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log _bin_trust_function_creators variable)"'', check into your .sql dump file that you don't have lines with '''...50003 TRIGGER...'''. They are lines that try to create triggers and that may be here if a trigger was manually inserted into your old database (Dolibarr common version does not need any trigger). | |||
= Test = | = Test = | ||