RE: [PHP] how to rename a database
| From: | Cal Evans | Date: | Wed, 24 Jan 2001 21:30:40 +0000 |
| Subject: | RE: [PHP] how to rename a database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-36480@lists.php.net to get a copy of this message | ||
Step 1:
Ask this question on the MySQL mailing list. :)
(Sorry, I couldn't resist)
The easiest way I can think of is to use MySQLDump to dump the schema and
data, delete the original database, change the output of mysqldump to
reflect the new database name and pump it back into mysql. Depending on
your database size, this may or may not work.
Cal
http://www.calevans.com
-----Original Message-----
From: Fang Li [mailto:fli@biographix.com]
Sent: Wednesday, January 24, 2001 3:21 PM
To: php-general@lists.php.net
Subject: [PHP] how to rename a database
Does anyone know how to rename a database in MySQL?
Thanks!
fang
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net