The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

extract data from mysql folders

Discussion in 'Database Discussions' started by Lyttek, Jan 29, 2011.

  1. Lyttek

    Lyttek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    770
    Likes Received:
    3
    Trophy Points:
    18
    Situation:

    A server crashed, rebuilt and restored. Last good backups were from August (don't ask).

    I've been able to locate the mysql folders for each database from the /var/lib/mysql directory on the recently crashed drive. So what I have now is this:

    A) new server with mysql databases running correctly from August of 2010.

    B) old server mysql files (on a linux box) with a folder for each database that was running up until Jan 25 when the crash happened.

    I have not done any configuration on the box where the old files are located, which means I can't yet do any kind of mysqldump.

    Q) would it be possible to install mysql on this working box, setup the databases as blank ones with the same names, stop the mysql server, copy the appropriate extracted directories, restart the mysql server and then do a dump??

    Or ???

    I'm open to suggestions.
     
  2. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello,

    As you are syncing mail to the new server, you can always sync mysql to the new server.
     
  3. Lyttek

    Lyttek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    770
    Likes Received:
    3
    Trophy Points:
    18
    nevermind! I was able to locate backups from the day before the crash, which include sql dumps!

    {insert over-joyous happy-dance here}
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,475
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    We love backups!
     
  5. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hello,

    Yoo..That's a good news!
     
Loading...

Share This Page