HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Need help moving MySQL to new computer (http://www.howtoforge.com/forums/showthread.php?t=59086)

zayde 14th October 2012 04:00

Need help moving MySQL to new computer
 
I need help reinstalling my MySQL database from a previous Windows XP computer that crashed, to a new one running Windows 7.
I was able to recover all the files from the old C: drive, and I would like advice on how to set up a reinstall of MySQL, and where to put the old files.

The original version of MySQL was 5.1, which is not current. Is it safe to proceed with 5.5 ?

falko 14th October 2012 18:34

To move the databases, you could create SQL dumps with phpMyAdmin and also restore them with phpMyAdmin on the new MySQL server.

dalitso 18th October 2012 22:24

Was this Mysql a stand alone installation, or perhaps bundled with WAMP or XAMMP?

zayde 19th October 2012 16:55

Help reinstalling MySQL database to new computer
 
I was able to get a successful reinstallation.

I did a clean install using the Windows installer, then replaced the new ibdata1 file with the one that I had recovered from the crashed computer. I didn't expect that to work so cleanly.

Thanks to everyone who offered assistance.


All times are GMT +2. The time now is 00:40.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.