Question

All databases have vanished / disappeared (mariadb).

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?

Subscribe
Share

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

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?

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!!!


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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