Hi Johann, I was asking for numbers of databases exist like you count it. "show databases" list all databases not counting. There is a row value after the list but filtering the system and default databases to removed.
Thanks --- On Mon, 9/20/10, Johann Vincent Paul Tagle <[email protected]> wrote: From: Johann Vincent Paul Tagle <[email protected]> Subject: Re: [plug] number of databases exist on mysql To: "Philippine Linux Users' Group (PLUG) Technical Discussion List" <[email protected]> Date: Monday, September 20, 2010, 1:49 PM 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 -----Inline Attachment Follows----- _________________________________________________ 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
