Results 1 to 2 of 2

Thread: Retrieve db mysql!

  1. #1
    Member
    Join Date
    Feb 2005
    Posts
    29

    Default Retrieve db mysql!

    Anyone can help!!! My hard drive failed. I reinstalled everything. Now i still have my old hard drive with the whole cpanel / whm installation on it. The question I have - is there a way to retrieve my mysqldb for all sites???

    Please I need help asap!!
    Sellwebhost.com

  2. #2
    Member
    Join Date
    Feb 2008
    Posts
    81

    Default

    There is as ive done this before! Im just going to try and find out where they were kept.. Just thought id post to let you know this can be done though and to calm your worries a bit if you had any

    Here we go then.. The info.. I know the below directory is where the information is stored but i cant remember 100% if this method works

    1) Stop the MySQL Server where you are copying the DB's too.
    # /etc/init.d/mysqld stop

    2) The usernames on both the new and old system must be the same for this to work! On the OLD HD copy each usernames DB's folders from /var/lib/mysql. Copy this information to /var/lib/mysql

    3) Start the MySQL Server again
    # /etc/init.d/mysqld start

    You should now be good to go

    Theres probably another way but that should do the job.. Let me know if you have any problems and let me know if it works please!
    Last edited by srobinson; 06-10-2008 at 01:12 PM.
    .:.:. Blackwhite Hosting - UK Shared Hosting .:.:.
    Official UK CPGS Mirror http://cpgs.blackwhite-hosting.co.uk/

Similar Threads

  1. Unable to retrieve key
    By edumadma in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 08-24-2009, 07:29 PM
  2. how can i retrieve my mysql server?
    By meeti in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 01-29-2008, 07:10 AM
  3. How Do I retrieve my backups?
    By paulstav416 in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 09-21-2006, 01:21 PM
  4. How Do I retrieve my backups?
    By chirpy in forum New User Questions
    Replies: 1
    Last Post: 09-21-2006, 11:15 AM
  5. Lost Password, How to Retrieve?
    By Daemon1 in forum cPanel & WHM Discussions
    Replies: 5
    Last Post: 03-10-2004, 02:22 AM