Re: [PHP] how to rename a database

2001-01-26 Thread Dominic
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

Re: [PHP] how to rename a database

2001-01-26 Thread Philip Olson
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

Re: [PHP] how to rename a database

2001-01-25 Thread php3
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

RE: [PHP] how to rename a database

2001-01-24 Thread Cal Evans
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.

Re: [PHP] how to rename a database

2001-01-24 Thread Chris Doyle
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