Clone MySQL database

Patrick McGrath's Avatar

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

    Matthieu Muffato's Avatar

    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

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac