Results 1 to 3 of 3

Thread: Migrating MySQL from Windows to Linux Server

  1. #1
    Join Date
    Nov 2007
    Location
    Bundaberg, Australia
    Beans
    31
    Distro
    Hardy Heron (Ubuntu Development)

    Migrating MySQL from Windows to Linux Server

    Hi everyone,

    I will soon have the task of moving a mysql database from Windows to Linux.

    How hard is this to do? Can someone point me in the right direction?

    I'm pretty new to MySQL.

    Cheers

  2. #2
    Join Date
    Mar 2008
    Beans
    1,755

    Re: Migrating MySQL from Windows to Linux Server

    Mysqldump is the standard command for backing up a DB on either Linux or Windows. Here is the Mysql reference page on mysqldump:

    http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html.


    It is going to be as easy use mysqldump to backup and then you will use mysql to restore like this:

    #mysql -u [USERNAME] -p [MYDATABASE] <./[MYDATABASEBACKUP]


    Just did this recently myself, good luck.

  3. #3
    Join Date
    Jun 2006
    Location
    Switzerland
    Beans
    Hidden!
    Distro
    Kubuntu Jaunty Jackalope (testing)

    Re: Migrating MySQL from Windows to Linux Server

    yes, mysqldump will be the preferred way. Although you might be able to copy the database binaries - but that often leads to problems.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •