Skip to content
Linux Server Support
  • Home
  • HowTo
    • Cpanel
    • Mail
    • MySQL
    • Nginx
    • Apache
    • CloudLinux
    • Ubuntu
    • WordPress
    • Magento
  • Tools
  • Hire Me

InnoDB

Find all MySQL databases using InnoDB engine

February 14, 2018 by Yujin Boby

To find all MySQL database using InnoDB MySQL engine, run mysql -N mysql -e “SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = ‘innodb’;” | cut -d” ” -f2 | sort | uniq MySQL

Categories MySQL Tags InnoDB Leave a comment
© 2026 Linux Server Support • Built with GeneratePress