Executing 'show databases' as mysql root user will show you all databases. As for which ones are actively being used, I'm not sure.
HTH, Johann On Mon, Sep 20, 2010 at 1:05 PM, Allen Umlas <[email protected]> wrote: > > Hi, > > Does anyone knows how to show or count > the number of databases exist in mysql? I'm referring to > databases not the "count" command. > > I want to know all active databases > cause im not sure if all of the clients and customers are > using or utilizing the database. > > Plan for migrating from old version to > new version without downtime but need all the information > before doing migrations. > > Oninz > > > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
