Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 14th October 2012, 05:00
zayde zayde is offline
Junior Member
Join Date: Aug 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 ?
Reply With Quote
Sponsored Links
Old 14th October 2012, 19:34
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts

To move the databases, you could create SQL dumps with phpMyAdmin and also restore them with phpMyAdmin on the new MySQL server.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 18th October 2012, 23:24
dalitso dalitso is offline
Join Date: Nov 2008
Location: South Africa
Posts: 43
Thanks: 3
Thanked 4 Times in 3 Posts
Send a message via Skype™ to dalitso

Was this Mysql a stand alone installation, or perhaps bundled with WAMP or XAMMP?
Reply With Quote
Old 19th October 2012, 17:55
zayde zayde is offline
Junior Member
Join Date: Aug 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3 system installation script Mark_NL Tips/Tricks/Mods 14 18th November 2014 07:34
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 21:03
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11

All times are GMT +2. The time now is 16:48.

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