All databases have vanished / disappeared (mariadb).

April 16, 2019 750 views
Databases MariaDB MySQL

Not sure if others are experiencing this, but it’s frightening. My Mariadb databases are all cleared up from the server. How, why? What is DO doing? All my Wordpress websites are now down. WHat happened?

3 comments
  • The mariadb server is on, btw. I can login as root in the shell, but when I do show databases it only has the default stuff that comes with MariaDB. Just an hour ago, all was well.

    I have rebooted the entire droplet. Doesn’t help.

    And I have raised a ticket, but received a sad auto-message from DO saying “our support is taking more time than usual”. While my websites are down!!!

  • Something is going on.

    THe “Contact DO” link now leads to some SalesForce stuff, which has some new logins. How many new logins will we have?
    https://cloudsupport.digitalocean.com/login?startURL=%2Fs%2Fcreateticket%3Ft%3D1555383433120

    More importantly, many things on my droplet have changed without any activity on my part. My rclone settings are changed (clients deleted). WTF? What’s happening at DO?

  • I have the same problem as well. Idk what happen to my droplet. All my database is gone. All my website down too

1 Answer

Hey friend,

I’m very sorry to hear of the trouble this is causing for you. I would advise not waiting for our support team to answer a ticket about this, as they will not have any direct insight to share and they actually have less access to your server than you do.

I would check /var/lib/mysql and see if the databases you are expecting to be present are actually present there. If they are not, you need to restore your backups. If they are there, then perhaps they are not owned by the correct user. You could try:

chown -R mysql. /var/lib/mysql
systemctl restart mysql

Those commands may vary slightly based on your situation, but cover a vast majority of default setups.

If they are listed in /var/lib/mysql and the above commands did not change anything, what user are you connecting to MySQL command-line as? Make sure it is the root user for good measure, so you can rule out specific issues with user permissions.

If all else fails again, restoring backups is probably not a bad idea. Spending hours hunting the “why” may not be the most productive way to get back online, regardless of it’s importance.

Jarland

Have another answer? Share your knowledge.