Hey guys! so… could use a bit of help.
I have an SQL dump file I want to import to SQLITE and or MySQL. It’s from MariaDB. but MySQL is saying syntax error, and SQLite is saying invalid format.
Basically. If a record has an apostrophe in the text, the entire file is screwed up.
INSERT INTO companies VALUES (1,994674,'Weber\\'s Water & Dozer Service, Inc.',5,'','Water Hauling, Oilfield Construction','',0,1438794320,'lap',1410976501,'lap',1382634317,'lap',1,1,'',0,'',0,'',999,0,'','',0,0);
Query OK, 1 row affected (0.00 sec)
I have a million records.
anyone know a solution I don’t?