1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    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?


  2. #2
  3. No Profile Picture
    Carpe Diem
    Devshed Newbie (0 - 499 posts)
    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)

    Darren http://www.php4hosting.com/

Similar Threads

  1. tranfer tables from mysql to postgresql in linux
    By muthayalap in forum Java Help
    Replies: 0
    Last Post: February 3rd, 2004, 10:13 AM
  2. Replies: 0
    Last Post: January 31st, 2004, 02:15 AM
  3. Replies: 24
    Last Post: January 13th, 2004, 04:20 PM
  4. Moving PHP & MySQL to win2000 from Linux
    By Ricta in forum PHP Development
    Replies: 0
    Last Post: January 13th, 2004, 04:19 PM
  5. Mysql & PHP from Linux to Win2000... H E L P ! ! !
    By Ricta in forum PHP Development
    Replies: 0
    Last Post: January 10th, 2004, 04:48 PM

IMN logo majestic logo threadwatch logo seochat tools logo