Without Transfer Tool, how can I check quickly to know if a server is using MySQL or SQLite?

jonathan.mann

Registered
Nov 6, 2019
3
0
1
Columbus, Ohio
cPanel Access Level
Root Administrator
I'm trying to do some quick confirmation and I'm running into a wall here. From the command line, it looks like running "mysql" and then "status" from the prompt yields practically identical information on servers using MySQL and SQLite. How can I confirm a server is one or the other?

Thank you!
 

cPanelAnthony

Administrator
Staff member
Oct 18, 2021
1,041
112
118
Houston, TX
cPanel Access Level
Root Administrator
Hello! The "mysql" vs "sqlite" matter only comes into the picture for Roundcube database types. You server will always run MariaDB or MySQL (which both use the same MySQL commands) as the databases type; however, the Roundcube mail client can use SQLite instead of MySQL. It is possible to simply check and see if there's a "roundcube" database in MySQL.

You can prompt mysql by using the "mysql" command and then show databases.

Code:
show databases;