Domain Manage

moving mysql from one server to another

Discussion in 'General Board' started by SecNam, Aug 7, 2005.

Thread Status:
Not open for further replies.
  1. SecNam

    SecNam Moderator Staff Member

    Joined:
    Jul 2004
    Posts:
    5,127
    Likes Received:
    37
    hi all.

    hope someone can guide me on this.

    I have a few mysql databases on a windows web edition server and need to move then to a server 2003 server.

    can anyone give an idiots giude on moving them.

    thanks in advance.
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
     
  3. admin Spain

    admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    10,083
    Likes Received:
    115
    First you need to dump your database from the old server using mysqldump as follows from a prompt:

    mysqldump -h host -u user -p database > dump_file

    Second you need to import the sql and data to the database using mysql as follows from a prompt:

    mysql -h host -u user -p database < dump_file

    After that it should be transfered correctly.
     
Thread Status:
Not open for further replies.

Share This Page