List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 27 2011 9:47am
Subject:Re: Schema list
View as plain text  
Is this a production setup.
If not, take complete dump of the all databases.
Drop the xYZ database, see if you can  see all the objects under XYZ.

Since the xYZ database is created, its obvious, that names are case
sensitive, and it show not show object from XYZ, when u under xYZ.

Can you please paste the results that your seeing.


On Wed, Jul 27, 2011 at 3:09 PM, Anupam Karmarkar

> There is one database name 'XYZ' on linux system, some one has mistakenly
> created new
> database name with 'xYZ', database is created when I use 'xYZ' database,
> there are no
> tables with SHOW TABLES, but when i run SHOW PROCEDURE STATUS it show
> procedures from
> 'XYZ' database.
> My concern is that if i drop new database created 'xYZ' will it drop
> procedures also
> listed from 'XYZ' database

Schema listAnupam Karmarkar27 Jul
  • Re: Schema listAnanda Kumar27 Jul