MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old June 14th, 2004, 03:24 PM
khn4074 khn4074 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 1 khn4074 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question HELP!!! Moving MySql from Linux to windows

I've recently been "asked" to take over as the database administrator for a project that I am an engineer on. I have some limited experiences with Linux, although I prefer Windows, apache, Php, and MySQL. I'm currently in the process of upgrading my database server. The old server is running Linux 7.1, Apache 1.3.19, & MySQL 3.23.36, the server I'm moving to is Windows 2000 running the most up-to-date software versions of Apache, Php, & MySQL. Can someone tell me, if it is possible to move the database from Linux to Windows, and if so, will the database continue to work? What steps do I need to follow in order to make sure the database will continue to work on the new server? Any additional information would be appreciated.

Reply With Quote
  #2  
Old June 15th, 2004, 07:21 AM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
 
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
Theoretically, you could just copy the db files from the /var/lib/mysql directory (or wherever they're stored on your system) over to the Windows box. Failing that, just do a big dump using mysqldump, copy the resulting text file over, and slurp it into the db on the Windows box.
__________________
Please don't PM me asking for solutions outside the scope of a thread.
Keeping all responses in a thread stands to help others who come along later,
which is after all what this forum's all about.

Reply With Quote
  #3  
Old June 16th, 2004, 07:40 PM
teniosoft teniosoft is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 1 teniosoft User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Sollution

Go ahead and just download mysql admin from the mysql website. Then backup the server and create it on the other server this is what I do. However, I highly recommend updating to a new version of linux and trying that out first. I is very good and much easier then 7.1 linux system. Go ahead and install webmin with it and you will have a great headless server that you can do just about anything with. Trust me it is worth the effort.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > HELP!!! Moving MySql from Linux to windows


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway