Skip to content

Fails to convert libgen_compact.sql #92

@redthing1

Description

@redthing1

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions