V5 migration: Difference between revisions
Jump to navigation
Jump to search
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...' |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
There are significant changes to the database schema in this new version of the software. | 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 | 1. Backup the current database | ||
mysqlhotcopy --port=XXXX -u XXXXXX -p XXXXXX coge_db backup_dir | <pre>mysqlhotcopy --port=XXXX -u XXXXXX -p XXXXXX coge_db backup_dir </pre> | ||
2. Update the code <br> | |||
<pre>cd CoGeX ; svn update cd | |||
CoGe_web ; svn update | |||
cd /opt/apache/CoGe ; svn update </pre> | |||
3. Run the migration script on the database <br> | |||
<pre>perl CoGeX/scripts/migrate_coge5.pl -db=coge_db -u=XXXXXX -pw=XXXXXX </pre> | |||
The migration script takes ~2 minutes to run. | |||
4. Restart mysql | |||
<pre>sudo service mysql restart </pre> | |||
4. Restart mysql | |||
sudo service mysql restart | |||
Latest revision as of 15:39, 18 September 2012
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