[ensembl-dev] exporting mysql DB sql and txt files

[Dan Staines]

On 01/09/2014 06:22 AM, Paul Linehan wrote:
>
>> >Does anyone know the mysql syntax to dump the *.sql and *.txt files from the
>> >database?
>
> What's wrong withhttp://dev.mysql.com/doc/refman/5.1/en/mysqldump.html?
> What .txt files?

You can dump a MySQL database into separate .sql and .txt files using 
the -T/--tab option of mysqldump, as described:
http://dev.mysql.com/doc/refman/5.5/en/mysqldump-delimited-text.html

However, you may find it easier to use mysqldump without any arguments 
to generate a single dump file that you can then direct into mysql to 
reload e.g.
http://dev.mysql.com/doc/refman/5.5/en/mysqldump-sql-format.html
http://dev.mysql.com/doc/refman/5.5/en/reloading-sql-format-dumps.html

Hope this helps,

Dan.

-- 
Dan Staines, PhD
Technical Coordinator, Ensembl Genomes
European Bioinformatics Institute (EMBL-EBI)
http://www.ebi.ac.uk/
http://www.ensemblgenomes.org/