Advice on re-setup after computer failure
Hi this is Lyn's tech support
Lyn has recently had a computer failure on her openvpms system that has resulted in the loss of her old system, but I have managed to recover the hard drive intact.
I was just wondering your advice on the best way to re-setup her new system:
I have all the MySQL files in the original ProgramData folder but not a MySQL-specific backup file so cannot recover via MySQL tools, only via copying of files.
1. What would be the most effective way to bring all the open vpms data from her previous machine (Windows XP) to her new system (Windows 8)? Is it possible to simply copy over the /data/ files and have the new MySQL install recognise these? Would doing so cause conflicts within openvpms?
2. The previous machine was running OpenVPMS 1.6, although I would like to be able to upgrade her to 1.7 while setting up the new system.
Is it advisable to re-install version 1.6 first, bring the data over and then upgrade to 1.7? Would there be problems or conflicts if I installed OpenVPMS 1.7 and then brought the data from 1.6 over?
Your advice and assistance is appreciated.
Re: Advice on re-setup after computer failure
Effectively you woul use a cold backup method to copy the mysql datafiles across to a new mysql instance. you can use tar or zip what ever works and you dont have to do all the data(you can ignore mysql table, performance tables etc) or just do the lot thats up to you.
hopefully her mysql was set for innodb 1 file per table. so u should see a directory openvpms with a stack of files inside it representing the tables.
follow the myqsl rules for cold backups and you should be fine. (make sure you copy the ibdata files as well (see the docs))
http://dev.mysql.com/doc/mysql-backup-excerpt/5.6/en/innodb-backup.html
See the link
make sure you use the same version of mysql for this dont go upgrading
once you have mysql up and running again
and verify the openvpms data is present.
the the next step would be reinstall tomcat deploy openvpms 1.7 run the
sql upgrade scripts defined in the package
upgrate/db/migrate1.6-1.7.sql
on the existing database.
load the new 1.7 archetypes
deploy the war to tomcat.
you can find this stuff in the README.txt that comes in the 1.7 package.
OH and finally configure a mysql backup solution for her I backup my system atleast daily using mysqldump but I have a slave system that keeps an exact parrellell copy as well for failover in under 5minutes downtown (potentialy less depending how fast I can execute my failover script)
Good luck
you can contact me offlist at
ben at charltonfamily.com.au if you need more help.
Re: Advice on re-setup after computer failure
Hi ben
Thanks for your advice, this has been extremely helpful. Recovery has been a success
I will organise her a full system and mysqldump backup as per your advice
Thanks again
tech