Restoring data
Hi,
I have just upgraded to a new notebook. When I bought my new notebook, the retailer removed the hard drive from my old computer to transfer documents to the new computer, and they can't get the old computer working after they returned the hard drive.
They have successfully installed the latest version of OpenVPMS on the new computer (runningWindows 7).
My problem is that I don't have a backup through MySQL, but I have a recent disk image on an external hard drive (through a parogram called Macrium Reflect).
Am I able to restore my data & settings etc from the external hard drive?
Cheers,
Ross Beatty
Re: Restoring data
Looking through these posts: http://dba.stackexchange.com/questions/174/how-can-i-move-a-database-fro... it sounds like you should be able to do it, but it would depend a lot on how the disk image was taken.
According to http://kb.macrium.com/KnowledgebaseArticle50101.aspx you should stop the MySQL server prior to running the backup; failure to do so may lead to database corruption.
If the server was shut down prior to running the backup, then it may be possible to recover it with the following steps:
1. shut the MySQL server down
2. rename the current MySQL data directory
This will be located in 'C:/ProgramData/MySQL/MySQL Server 5.1/Data/ or similar. You can find out by checking the datadir property located in my.ini
3. restore the data directory from backup to the current data directory
4. restart the MySQL server
-Tim
Re: Restoring data
Hi Tim,
Thanks for the advice.
I can't find the data in my external hard drive, so I might pass the information to someone with more IT knowledge than me.
Thanks again,
Ross
Re: Restoring data
In general, you should always use MySQL tools such as mysqldump to take backups of MySQL.
Yuri Sos has put together a tutorial for backups using the MySQL GUI Tools here: http://www.openvpms.org/backing-and-restoring-your-openvpms-data
-Tim