en; Brandon Lewis; [EMAIL PROTECTED]
> Subject: RE: Is it possible to Rename Database
>
>
> Or, use mysqldump to dump the entire database, edit the CREATE
> DATABASE line
> at the top to the new name and pipe it all back into mysql, then drop the
> old one?
>
>
It's the only way with InnoDB short of renaming each table in the
format:
RENAME TABLE olddb.table1 TO newdb.table1
Ken
>
> That's sort of taking the long way around the barn, isn't it?
>
> Will
>
-
Before posting, please check
ginal Message-
> From: Ravi Raman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 6:04 PM
> To: Carsten H. Pedersen; Brandon Lewis; [EMAIL PROTECTED]
> Subject: RE: Is it possible to Rename Database
>
>
> Or, use mysqldump to dump the entire database, edit the
; [EMAIL PROTECTED]
Subject: RE: Is it possible to Rename Database
> Is it possible to rename a database?
I would assume that the only way to do is is to
shut down the server, then rename the directory
of the database.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit
> Is it possible to rename a database?
I would assume that the only way to do is is to
shut down the server, then rename the directory
of the database.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Hi Brandon,
It is possible if you are you are using myisam or DBD table types,
but you have to rename the directory from the Unix shell prompt.
There is not yet a RENAME DATABASE command (althought it is on the
todo list) and no way that I know of (short of renaming each table if
you only have
