Database Missing after Restore from Snapshot

August 9, 2014 5.3k views
jimc
By:
jimc

I needed to restore my droplet from a snapshot after a problem. But now my WordPress database seems to be inaccessible or missing. Doesn't restore from snapshot restore all data and files?

1 comment
  • zainali202 October 26, 2015

    Log in as super user or use sudo
    Open /etc/mysql/my.cnf using gedit
    Find bind-address, and change its value to the database server host machine's IP address. For me, it was localhost or 127.0.0.1
    Save and close the file.
    Come back to terminal and execute sudo service mysql start

    And it worked for me.

Log In to Comment
4 Answers
Niko October 1, 2014

One cause might the change of the IP address. Check the mysql configuration file.

sudo nano /etc/mysql/my.cnf

Scroll down to "bind-address = ", and update the IP number with the new IP of your droplet.

bind-address        = XX.XXX.XXX.XX

Save the changes of the file and do restart.

sudo service mysql restart
Reply
asb MOD August 11, 2014

Hi,

Snapshots take a full system image. All files, including your MySql database, will be present when you restore from a snapshot.

Are you seeing error messages when you attempt to connect to the database? What is the output of:

mysqladmin -u root -p status

Is there anything in the error log? Run:

tail /var/log/mysql/error.log
Reply
contact614061 September 20, 2014

hello, i have the same problem, resized from snapshot and nothing is working, no mail, no web, no ssh
i am very preoccupied

Reply
ntminh188 June 16, 2017

yes, i meet this error also. After restore a snapshot, i can not connect to any database. Whats wrong here?

Reply
Have another answer? Share your knowledge.