Over time our server has grown and we’re now hosting quite a number of client sites, most of which utilise a MySQL database for one reason or another (most often for WordPress).
I’ve got a particular naming standard to keep databases grouped and as I only access our server via the command line this habit of using naming schemes means that I can easily search for those groups of databases using the following MySQL command.
SHOW DATABASES LIKE "prefix%";
Obviously you’d replace ‘prefix’ with whatever your naming schema dictates!
Comments