I'd like to access the libgen metadata database dump for information on when every scientific article was added.
I tried the following method:
- download
libgen_compact_2017-03-22.rar from http://gen.lib.rus.ec/dbdumps/
- extract
backup_ba.sql from the RAR file
- import into an SQLite database, i.e.
sqlite3 libgen.db -init backup_ba.sql
However, I'm getting a bunch of errors with the SQL:
Error: near line 15: near "unsigned": syntax error
Error: near line 87: near "LOCK": syntax error
Error: near line 89: near "s": syntax error
Error: near line 91: near "magest": syntax error
Error: near line 118: unrecognized token: "\"
Error: near line 137: unrecognized token: "\"
Error: near line 138: near "s": syntax error
Error: near line 141: near "Коннор": syntax error
Error: near line 153: near "s": syntax error
Error: near line 154: near "Белые": syntax error
Error: near line 166: unrecognized token: "\"
Error: near line 172: near "94": syntax error
There errors continue (not shown). I was thinking this was an encoding or locale issue, but backup_ba.sql appears to be utf8 encoded.
I'd like to access the libgen metadata database dump for information on when every scientific article was added.
I tried the following method:
libgen_compact_2017-03-22.rarfrom http://gen.lib.rus.ec/dbdumps/backup_ba.sqlfrom the RAR filesqlite3 libgen.db -init backup_ba.sqlHowever, I'm getting a bunch of errors with the SQL:
There errors continue (not shown). I was thinking this was an encoding or locale issue, but
backup_ba.sqlappears to be utf8 encoded.