MySQL & HAGR
============

MySQL can be downloaded here:

https://dev.mysql.com/downloads/mysql/

(note the root password during installation) 

Take an export of the database from the beta site. To do this logon to the test beta site::

  ssh admin@ageing-map.org

Create a suitable directory e.g. ~/exports to store the exported MySQL data::

  cd ~/exports
  mysqldump -u hagr_beta -p dev_genage_human > dev_genage_human.sql --lock-tables=false
  mysqldump -u hagr_beta -p dev_anage > dev_anage.sql --lock-tables=false
  mysqldump -u hagr_beta -p dev_genage_models > dev_genage_models.sql --lock-tables=false
  mysqldump -u hagr_beta -p dev_gendr > dev_gendr.sql --lock-tables=false
  mysqldump -u hagr_beta -p dev_longevity > dev_longevity.sql --lock-tables=false
  mysqldump -u hagr_beta -p dev_orthologs > dev_orthologs.sql --lock-tables=false

Transfer the above data across to your local environment.

Log on to MySQL locally using::

  $  mysql -u root -p

Which will then prompt for the root password

Next create the databases::

  CREATE DATABASE dev_genage_human;
  CREATE DATABASE dev_anage;
  CREATE DATABASE dev_genage_models;
  CREATE DATABASE dev_gendr;
  CREATE DATABASE dev_orthologs;
  CREATE DATABASE dev_longevity;

Then load the data using the SQL dump files taken earlier from the beta site e.g.::

  mysql -u root -p -h localhost dev_genage_human < dev_genage_human.sql 
  mysql -u root -p -h localhost dev_anage < dev_anage.sql
  mysql -u root -p -h localhost dev_genage_models < dev_genage_models.sql
  mysql -u root -p -h localhost dev_gendr < dev_gendr.sql
  mysql -u root -p -h localhost dev_longevity < dev_longevity.sql
  mysql -u root -p -h localhost dev_orthologs < dev_orthologs.sql