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 Ge
at a mysql prompt in the database where your table resides, type the
following:
alter table rename ;
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 (http://www.php.net/)
> T
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
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 ot
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
5 matches
Mail list logo
