Migrate MySQL from Linux to Win98

Hi, I have a MySQL database on a Linux machine, how do I move the entire database to Win98 MySQL without creating a new database?

Thanks.

vic

You will have to recreate the database, the best method is :-

To export an existing database use the following commands using mysqldump :-

mysqldump -u root -p database_name [table] > filename_to_export_into

That will prompt you for your password and export the database into a script that you can use to recreate the database on another instance of MySQL:

mysql -u root -p database_name < input_file_name (which was previously output_file_name)

Regards
Darren http://www.php4hosting.com/