September 18th, 2000, 08:51 PM
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?
September 19th, 2000, 06:22 AM
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)