V5 migration

From CoGepedia
Revision as of 00:41, 18 September 2012 by Mbomhoff (talk | contribs) (Created page with 'There are significant changes to the database schema in this new version of the software. Existing databases must be migrated to v5 using the migration script. Here are the ste...')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

There are significant changes to the database schema in this new version of the software. Existing databases must be migrated to v5 using the migration script. Here are the steps:

1. Backup the current database mysqlhotcopy --port=XXXX -u XXXXXX -p XXXXXX coge_db backup_dir

2. Update the code cd CoGeX ; svn update cd CoGe_web ; svn update cd /opt/apache/CoGe ; svn update

3. Run the migration script on the database perl CoGeX/scripts/migrate_coge5.pl -db=coge_db -u=XXXXXX -pw=XXXXXX

The migration script takes ~2 minutes to run.

4. Restart mysql sudo service mysql restart

Retrieved from "https://genomevolution.org/wiki/index.php?title=V5_migration&oldid=5249"