Moving MySQL Databases onto a new hard drive. HELP!

Discussion in 'MySQL' started by Help_, Jun 27, 2006.

0
  1. #1
    Hello, I have a dedicated server running windows 2003 + plesk. Yesterday, the OS had to be reinstalled on a new hard drive. All the files+databases are intact on the older hard drive. How do I move the mysql databases that are present on the older hard drive, onto the newer one? Remember, the newer one is running a fresh OS install. Help is greatly appreciated.
     
    Help_, Jun 27, 2006 IP
  2. Help_

    Help_ Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Please reply ASAP.
     
    Help_, Jun 27, 2006 IP
  3. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    with mySql you simply have to copy the old files /data file to the new /data file.
    a.) Switch off MySql server
    b.) Backup or rename current new/data directory
    c.) copy old/data directory to new/data directory
    d.) Swith on MySql server
    e.) Test
    f.) If it fails you will need to "export " Full SQL data and Import it into the new harddrive.

    Give me green points if this helps you ;)
     
    sadcox66, Jun 27, 2006 IP