Home → Questions →

Clone MySQL database

• Edit

Patrick McGrath

16 Jun, 2015 03:36 PM

Hi,

I was wondering if it was possible to clone the mysql database. The data dumps seem to be missing some files for some of the treefamilies. Using the API seems pretty slow - it takes around 10 minutes for me to download data using the get_families.pl. I would like to do this on ~25,000 proteins so i was thinking making a local version of the mysql database would be the best solution. I couldn't find any ftp sites to use.

Thanks,
-Patrick

1. Support Staff 1 Posted by Matthieu Muffat... on 19 Jun, 2015 10:07 AM

   

   Dear Patrick

   Yes you can clone the database with mysqldump -utreefam_ro -hmysql-treefam-public.ebi.ac.uk -P4418 --skip-lock-tables treefam_production_9_69

   Matthieu

   • Edit

2. Matthieu Muffato closed this discussion on 16 Jun, 2020 04:08 PM.