Schema list

Schema list

am 27.07.2011 11:39:18 von Anupam Karmarkar

--0-1872299936-1311759558=:62694
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

There is one database name 'XYZ' on linux system, some one has mistakenly c=
reated new=0Adatabase name with 'xYZ', database is created when I use 'xYZ'=
database, there are no=0Atables with SHOW TABLES, but when i run SHOW PROC=
EDURE STATUS it show procedures from =0A'XYZ' database.
My concern is that if i drop new database created 'xYZ' will it drop proced=
ures also=20
listed from 'XYZ' database=0A
--0-1872299936-1311759558=:62694--

Re: Schema list

am 27.07.2011 11:47:08 von Ananda Kumar

--20cf3005df068dd2c404a909ee90
Content-Type: text/plain; charset=ISO-8859-1

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.

regards
anandkl



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

> 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
>

--20cf3005df068dd2c404a909ee90--