Posts tagged Find all database using Innodb engine

List all databases using Innodb storage engine

While working on a server migration,  I need  to found all databases running on Innodb engine to migrate  them over to  a new server.

So, thought of  sharing  the command to get the list of all innodb databases, if in case anyone requires it. 🙂


Below is the command ::


[email protected][#] mysql -N mysql -e "SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';" | awk '{print $1}' | sort | uniq

That’s all, easy isn’t it.