You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This pertains to the ChEMBL 28 MySQL download.
It appears not to escape single quotes within strings, so it's very difficult to import.
These types of lines are problems:
''Growth inhibition of human HOP92 cells after 48 hrs by CellTiter-Blue ce' at line 1
Because ' is not escaped, source downloaded_file.sql fails.
(Also: The http server seemed to halt the download partway, leading to downloading incomplete files. I tried download with curl and wget multiple times but ended up with corrupted tar.gz files that were much to small (< 1 GB, often). I was only able to get the files via FTP using /usr/bin/ftp.)
Edit: The create table lines are fine, just escaped by ''.
The text was updated successfully, but these errors were encountered:
Hi,
This pertains to the ChEMBL 28 MySQL download.
It appears not to escape single quotes within strings, so it's very difficult to import.
These types of lines are problems:
Because
'
is not escaped,source downloaded_file.sql
fails.(Also: The http server seemed to halt the download partway, leading to downloading incomplete files. I tried download with curl and wget multiple times but ended up with corrupted tar.gz files that were much to small (< 1 GB, often). I was only able to get the files via FTP using
/usr/bin/ftp
.)Edit: The create table lines are fine, just escaped by ''.
The text was updated successfully, but these errors were encountered: