#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    Mysql database disapeared


    Hi,

    After a sudden loss of power at the datacenter, the server that rebooted when the power supply has returned is now NOT showing the databases when I run: show databases;

    I have check the folder /var/lib/mysql and the databases are there!

    Any idea how I can recover them?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0
    What I get back is:

    mysql> show databases;
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | test |
    +--------------------+
    2 rows in set (0.00 sec)

IMN logo majestic logo threadwatch logo seochat tools logo