Re: **newbie question** renaming a database

[gerald_clark]

Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in order to do
something as simple as this. is there another way? as mysql user
'root' i've tried:
mysql> rename database old_db to new_db
thnx,
cheers!
-a
 

You may think this is simple, but you have to make sure all users are 
out of the database, and all records are flushed
before it could be renamed.  It is much safer to shutdown the server and 
rename the directory.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]