at a mysql prompt in the database where your table resides, type the
following:
alter table currentname rename newname;
That should take care of it.
--
Dominic
Fang Li wrote:
Does anyone know how to rename a database in MySQL?
Thanks!
fang
--
PHP General Mailing List
Here's a FAQ on renaming a mysql database :
http://www.faqts.com/knowledge_base/view.phtml/aid/1262/fid/102
If anyone has useful words to add to it then do so.
Philip
Fang Li wrote:
Does anyone know how to rename a database in MySQL?
Thanks!
fang
--
PHP General Mailing
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
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.
Prehaps you can rename the database file in mysql/bin
ie. database_name.sql to new_database_name.sql and that will work?
___
This email may contain confidential and/or privileged information for the
sole use of the intended recipient. Any review or distribution by
5 matches
Mail list logo