|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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.
|
|
#2
|
||||
|
||||
|
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. |
|
#3
|
|||
|
|||
|
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.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > HELP!!! Moving MySql from Linux to windows |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|