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

[Rishi Nag]

On Thu, 09 Jan 2014 06:22:56 -0000, Paul Linehan <linehanp at tcd.ie> wrote:

>> Does anyone know the mysql syntax to dump the *.sql and *.txt files  
>> from the
>> database?
>
>
> What's wrong with http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html?

In addition, to reduce the likelihood of file/SQL statement size issues we  
to do the dna table separately and use the net_buffer_length flag

mysqldump -u username -h host (add password and port if required)  
--add_drop_table mydb --ignore_table="mydb.dna" --net_buffer_length=15000   
> backup.sans_dna.sql

mysqldump -u username -h host (add password and port if required)  
--add_drop_table mydb dna --net_buffer_length=15000  > backup.dna.sql

Regards

Rishi

-- 
Using Opera's mail client: http://www.opera.com/mail/