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 a few tables) of renaming a INNODB table.  This is not
to be done lightly.

Remember to shutdown the server before raming the directory and change
any permissions (GRANT) that might be applicable.
The rename the directory then restart the server.

Best of luck
Ken
----- Original Message -----
From: "Brandon Lewis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 12:57 PM
Subject: Is it possible to Rename Database


> Is it possible to rename a database?
>
>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to