Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Unanswered: Migrating database

    ok after a lot of fiddling about I finally manged to get MySQL v4.1.9 working on a new server I am going to be moving all my old MySQL version (4.0) databases to.

    I wanted to update the root password as I felt the old one was insecure and that works fine. The problem I have now is how to move 50+ databases along with the associated username and passwords from one server to another.

    At the moment I have the mysql server IP set in phpMyAdmin on my ne server to my old server, its very slow as there happens to be 6,000 miles seperating the servers

    So my question is what is the best way to move the databaes from one server to another at the same time retaining all the usernames and passwords?

    My users have all been infomed that the MySQL IP address will be changing and if they have it hardocded into their apps, to change it once the move is complete..

    Both servers are running windows 2003...

    TIA

  2. #2
    Join Date
    Apr 2004
    Posts
    10
    Can anyone provide guidance on this? thanks.

Posting Permissions

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