I try to load an SQL dump into a MySQL database.
The dump contains a .sql
file which creates all tables in the database. Along with the .sql
file, there are tab separated .txt.gz
files with the data for the tables. The file name matches the table name and the file contains no headers.
database.sql
table1.txt.gz
table2.txt.gz
table3.txt.gz
- ...
Question: Was this created with a standard dump tool? Is this a standard database dump format? Can load this with e.g. mysql
, mysqldump
or something similar?
I know of course that I can iterate the files and load them one by one.
The data comes from: ftp://ftp.ensembl.org/pub/grch37/release-94/mysql/homo_sapiens_core_94_37/