Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004

    Unanswered: Recover Database

    Hi all!

    I'm completely new to MySQL and I tried to do my homework (I RTFD), but I can't figure out what to do and am in quite a hurry to find out. So here goes...

    My situation: I have two hard disk drives in a server at a hosting company, one is the old one with a dead RH9 installation (very strange RPM issue, http and php completely messed up). On this one is also an old MySQL database with LOTS of information that otherwise would have to be reentered by hand by me and about a dozen other peole.

    On the new disk, there is a shiny, brand-new installation of RH9 with a virgin database. Can I somehow copy the old database to that new installation? If so, how? I can't just try and see what happens, because each manual reboot costs me money. Also I pay for the time both disks are still in my machine. I would appreciate any input.

  2. #2
    Join Date
    Jan 2003
    Paris, France
    If you use MyIsam table type (which is the default with MySql) you can copy the databases file from one disk to an other.
    You just need to change permission on the database folder and restar Mysql server.
    You may not have to reboot the server but you need kill and restard mysqld.
    Olivier Miossec

  3. #3
    Join Date
    Apr 2004


    if you are like, me a newbie, not that good at a command line, i recommend myManager. it has the capability to do the job that you describe in GUI... you can easily navigete through the backup facility...

Posting Permissions

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