MySQL newbie question 1

[tmryan]

I'm thinking about getting started with mySQL. I'm getting into WEB development and playing with PHP. Does MySQL come in different flavors? My home PC's are WIN98 & WIN 2000, but my website is hosted on a Linux server. How do I maintain data on a MySQL DB in Windows and then transfer it to a Linux server?

Thanks
Tim Ryan

 

[rycamor]

You can install MySQL on Windows (

http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.38-win.zip),

and it should run almost no different than MySQL on Linux. (See

http://www.mysql.com/doc/W/i/Windows_vs_Unix.html).

To transfer your data, learn to use mysqldump (

http://www.mysql.com/doc/m/y/mysqldump.html)

to dump the structure and contents of your database to a text file. This text file contains all the SQL queries and INSERT statements needed to re-build your database on another MySQL server.

You can also install Apache for windows, to most closely emulate your server environment. Even better, there is a project that allows you to download a program that will install PHP, Apache, and MySQL all at the same time:

http://www.phpgeek.com/phptriad.php