Moving the database is childs play. I'm sure other tools allow you to do this, but when I recently started working with MySQL, I found PremiumSoft MySQL Studio (30 day trial, $78 to purchase) from http://www.mysqlstudio.com It is a pretty decent tool, and among other things includes a Backup/data transfer wizard that lets you very easily move a database from one server to another.
Add to that, I designed my first MySQL database on MySQL version 4 on my own Win2k box, and transferred it to verion 3.23.xx on a Linux server across the web (just make sure port 3306 is open on the target server). Regards, Tore. ----- Original Message ----- From: "Theisen, Gary" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 12:59 PM Subject: From Win2000/IIS to Linux/Apache ? > Hi all, > > I have PHP & MySQL installed on a Win2000/IIS system. I may be moving (due > to requirements at work) to a Linux/Apache system in the near future. > > I'm wondering if it's a hassle, or even possible, to move the MySQL database > from the windows/IIS box to the Linux/Apache box? Any corruption, or other > problems associated with this type of move? > > Thanks! > > P.S. I also have the option of leaving Win2000 in place but switching to > Apache service. Would this be "worth" it? In other words, would that setup > be a better web server environment (for PHP & MySQL) than the Win2000/IIS > setup? > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php