Show processlist;
From: [email protected] [mailto:[email protected]] On Behalf Of Johann Vincent Paul Tagle Sent: Monday, September 20, 2010 6:49 AM To: Philippine Linux Users' Group (PLUG) Technical Discussion List Subject: Re: [plug] number of databases exist on mysql 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
