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.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th October 2012, 04: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
  #2  
Old 14th October 2012, 18:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

To move the databases, you could create SQL dumps with phpMyAdmin and also restore them with phpMyAdmin on the new MySQL server.
__________________
Falko
--
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
  #3  
Old 18th October 2012, 22:24
dalitso dalitso is offline
Member
 
Join Date: Nov 2008
Location: South Africa
Posts: 43
Thanks: 3
Thanked 4 Times in 3 Posts
Send a message via Skype™ to dalitso
Default

Was this Mysql a stand alone installation, or perhaps bundled with WAMP or XAMMP?
Reply With Quote
  #4  
Old 19th October 2012, 16: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
Reply

Bookmarks

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 12 7th March 2014 06:30
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 20:03
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11


All times are GMT +2. The time now is 04:52.


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