At 11:01 +0530 10/11/02, Insanely Great wrote: >Greetings... > >I dont think that there is any SQL statement to do that. > >As of changing the name, You can just go to the data directory of MySQL and >change the name of the directory of the database. MySQL stores each database >as a directoyr so changing the name of the directory will change the name of >the database.
Make sure to FLUSH TABLES first. But it won't work if you have InnoDB tables, and isn't supported if you have BDB tables. > >I have tried this with MyISAM and ISAM tables, not sure of other table >types. See above. Best just to do what others have suggested: use mysqldump to dump the database, create the new database, and reload the dump file into it. > >Rgds >Insane >SQLyog - The Definative GUI for MySQL >http://www.webyog.com/sqlyog > >----- Original Message ----- >From: "Scott Pippin" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, October 11, 2002 4:25 AM >Subject: copy one database to another > > >> I have one database(test) i would like to copy over to (test1). Ehat is >> the syntax to do this? Is there any to just change the name of the >> database? >> >> Thanks in advance > > (query, mysql) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php