27,411
edits
Changes
Jump to navigation
Jump to search
mLine 94:
Line 94: + +
→If you have technical knowledge in Mysql database management software
[[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 =