Addressed to: "Chris Doyle" <[EMAIL PROTECTED]>
"Fang Li" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
** Reply to note from "Chris Doyle" <[EMAIL PROTECTED]> Thu, 25 Jan 2001 09:38:55
+1000
To be completely safe:
cd /var/mysql # or where ever your databases are stored.
mysqladmin -p shutdown # shut down database to make sure all
# tables are flushed, and closed
mv OldDbName NewDbName # rename the directory
safe_mysqld & # restart mysqld
mysql -p # Reassign the permissions
>REVOKE all users of the old table name
>GRANT all users of the new table name
>
> Prehaps you can rename the database file in mysql/bin ie.
> database_name.sql to new_database_name.sql and that will work?
>
> ----- Original Message ----- From: "Fang Li" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]> Sent: Thursday, January 25, 2001 7:20
> AM Subject: [PHP] how to rename a database
>
>
> >
> > Does anyone know how to rename a database in MySQL?
> > Thanks!
> >
Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
