Moving old data from crashed computer to new computer
We've been using a laptop to run RGP for our small wall in a rec centre. This laptop crashed on us and we cannot log in or even turn it on. We do however have access to the hard drive. We now have a new computer with RGP installed and a new MySQL database made. Is there any way we can move the data from the dead computers' hard drive to the new database?
We have started entering in new participants so if we can merge the two databases that would be ideal.
Thanks!
Comments
I presume you are not on the support plan, as otherwise you would have an offsite backup.
It's not the least bit trivial to migrate a crashed MySQL database to a new computer, but it can be done. You'll need to figure out how to mount that MySQL database on the harddrive, do a mysqldump, and then import that information into the new MySQL. And this would be a complete recovery of the database, i.e. you can't merge it.
Regardless of how you get the new database setup, be sure to use the integrated RGP backup feature to another drive or USB drive to prevent this headache in the future.
We can certainly help, but it will be one-time support incidence.
Hope this helps
Andy
Thanks we'll work on that. Is there anyway we can start inputting data now while we work on restoring the data?
There is no way to merge two different databases, thus you can't be working on a new database and expect to import changes from your old database or vice versa.
Hi, I'm reviving a old thread - I'm in the exact same situation. I'm sure lots of people would benefit from this information - can you please give instructions on how to "mount that MySQL database on the harddrive, do a mysqldump, and then import that information into the new MySQL." as you have described above?
Best regards
The steps required are highly variable.
That being said, if you can get access to the /data folder within the MySQL Server directory then there is hope. As for mounting the crashed hard drive, you'll need to contact a local skilled IT person for that.... we can't help with that. But if you can zip the "c:\program files (x86)\mysq\MYSQL Server 5.0\data" folder up and email to us we can probably recover the data - though it will require a few hours of support for us to restore a working RGP database from those files.
Hope this helps,
Andy
Please sign in to leave a comment.