Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

extract data from mysql folders

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

  1. Lyttek

    Lyttek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    770
    Likes Received:
    3
    Trophy Points:
    168
    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:
    5
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Hello,

    As you are syncing mail to the new server, you can always sync mysql to the new server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Lyttek

    Lyttek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    770
    Likes Received:
    3
    Trophy Points:
    168
    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:
    16,526
    Likes Received:
    430
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    We love backups!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. LinuxTechie

    LinuxTechie Well-Known Member

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

    Yoo..That's a good news!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice