Or if "RENAME DATABASE" is not implemented yet:
CREATE newDatabase;
then for each table in the oldDatabase issue:
ALTER TABLE oldDatabase.tblX RENAME TO newDatabase.tblX
After all is done:
DROP oldDatabase
-- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
--
MySQL
Yeah, in SQL:
RENAME DATABASE start_name TO new_name;
-Micah
On 04/12/2007 01:34 AM, Octavian Rasnita wrote:
Hi,
How can I rename a database if it contains InnoDB tables?
I have tried renaming the directory where it is located, but it
doesn't work this way.
Is there a method that works fa
Hi,
How can I rename a database if it contains InnoDB tables?
I have tried renaming the directory where it is located, but it doesn't work
this way.
Is there a method that works faster than dumping it with mysqldump then
re-create it under another name?
Thanks.
Octavian
--
MySQL General
MH,
Thursday, April 18, 2002, 11:50:12 PM, you wrote:
M> Is there a "sanctioned" way to rename a MySQL 3.23.x database, consisting
M> of MyISAM tables?
1. Take down the MySQL server.
2. Rename dir, that contains tables(files) of your database.
3. Start the MySQL server.
4. Don't forget to corr
Is there a "sanctioned" way to rename a MySQL 3.23.x database, consisting
of MyISAM tables?
Thanks,
MH
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
