Need help on Transfer MySQL database to different server...

Discussion in 'MySQL' started by gnosis, Dec 28, 2006.

  1. #1
    Hi, All...
    I am new here and also new to database. I need help/advise on transfer database... My problem is
    I have setup a server in my headoffice (Win 2000, IIS, MySQL, ASP) and I do all my update here.
    And I have several PC at several outlets (Win2000, IIS, MySQL, ASP). Every morning when the PC at outlets restart, they need to download the database from headoffice and update the database on it's own. So the website display on outlet actually calling the database locally and even the network is down they will have no problem to display the website.

    Any ppl can help to give me some guidelines or any tutorial/books for this? Thank you very much for help...
    :)
     
    gnosis, Dec 28, 2006 IP
  2. mr_dean

    mr_dean Peon

    Messages:
    280
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    use mysqldump and produce SQL file. Run that SQL file in another server.
     
    mr_dean, Dec 30, 2006 IP