mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Fails to convert libgen_compact.sql

Open redthing1 opened this issue 1 year ago • 1 comments

Data source is libgen_compact.sql from one of the libgen_compact*.rar archives that can be found here: https://data.library.bz/dbdumps/

I get this error running the command:

❯ ./mysql2sqlite/mysql2sqlite libgen_compact.sql | sqlite3 libgen_compact_20230606.db
memory
Parse error near line 2831: near "SET": syntax error
   FOR EACH ROW BEGIN  INSERT INTO `updated_edited` SET  `Title` = OLD.`Title`,
                                      error here ---^

Honestly I'm not quite sure what is wrong here. Any idea?

redthing1 avatar Jun 06 '23 22:06 redthing1