Thanks for the information. -----Original Message----- From: Paul DuBois To: Victor Pendleton; '''Chen, Jenny ' ' '; ''''[EMAIL PROTECTED]' ' ' ' Sent: 4/16/04 11:18 AM Subject: RE: rename database
At 11:03 -0500 4/16/04, Victor Pendleton wrote: >Paul, >Do you know if there will be an >ALTER DATABASE RENAME curName TO newName >implementation? I don't know. I agree it would be nice, though somewhat tricky. One workaround is to use mysqldump to dump the database, create the new database, reload the dump file into the new database, then drop the old database. That is, in effect, a database rename, although (I suspect) it can cause problems if you have foreign key relationships that refer to the table names in the original database. Another approach is to create the new database, and then, for each table in the original database, use RENAME TABLE orig_db.t TO new_db.t to move the table from one database to the other. Then drop the old database. > > >-----Original Message----- >From: Victor Pendleton >To: 'Paul DuBois '; Victor Pendleton; ''Chen, Jenny ' '; >'''[EMAIL PROTECTED]' ' ' >Sent: 4/16/04 10:55 AM >Subject: RE: rename database > >Oversight on my part. This will not work for those table types. > >-----Original Message----- >From: Paul DuBois >To: Victor Pendleton; 'Chen, Jenny '; ''[EMAIL PROTECTED]' ' >Sent: 4/16/04 10:43 AM >Subject: RE: rename database > >At 10:28 -0500 4/16/04, Victor Pendleton wrote: >>You can rename it at the filesystem level. > >What if you have InnoDB or BDB tables? > > >> >>-----Original Message----- >>From: Chen, Jenny >>To: '[EMAIL PROTECTED]' >>Sent: 4/16/04 10:18 AM >>Subject: rename database >> >>Experts: >> >>Is it possible to rename existing database ? > > >-- >Paul DuBois, MySQL Documentation Team >Madison, Wisconsin, USA >MySQL AB, www.mysql.com > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
