Oops sorry I thought you want to show OR count. Take a look at the
information_schema database. If I understand you right now then I think a
"select count(*) from information_schema.SCHEMATA where schema_name not in
('mysql','information_schema');" will do it.
Johann
On Mon, Sep 20, 2010 at 2:08 PM, Allen Umlas <[email protected]> wrote:
> 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]<http://mc/[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
>
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
http://lists.linux.org.ph/mailman/listinfo/plug
Searchable Archives: http://archives.free.net.ph
