1

An Ubuntu upgrade (to 19.10) messed up my database server. After the upgrade, the sql server would not start. So I installed MySQL but later realized that I may have been using MariaDB.

Is there a way to find out based on the table's content, what I was previously using -- if MariaDB or MySQL?

I have two folders: one is named var/lib/mysql/ and the other is /var/lib/mysql-10.2; they have .frm,.MYD, and .MYI files.

I am thinking it would matter to reinstall the same sql engine.

I since tried to get the database working again, but without any success. I tried to uninstall MySQL and MariaDB in order to freshly install MariaDB. But I somehow can't get it working. More on that front here on my unix.stackexchange.com post.

Update

running dpkg --get-selections I get

...
mysql-client-8.0        install
mysql-client-core-8.0   install
mysql-common            install
mysql-server-8.0        install
mysql-server-core-8.0   install
mysql-utilities         deinstall
...
  • Run dpkg --get-selections and see what you have installed. – Zoredache 2 days ago
  • @Zoredache see update – MeSo2 yesterday
0

If it is actually running, this may be the least invasive way of asking it what version it is:

mysqld --version

That should work equally well for either MySQL or MariaDB or Percona. Example:

$ mysqld --version
mysqld  Ver 5.6.22-71.0 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release 71.0, Revision 726)
  • The problem is that the server is not running. The only information I have available are the database files, and possibly some logs. – MeSo2 21 hours ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.