hi,
I have a solution. Please my blog's http://www.fire9.cn/?p=132.
good luck.
-
Ding Hao/Fire9 DB Architect
Emailmsngtalk: fire9di...@gmail.com
My Blog:http://www.fire9.cn
My Twitter: http://twitter.com/fire9
在 2009-4-7,上午12:20,
Hi shuly,
1 Use innodb_file_per_table.
2 Create new database.
3 Take the dump of old database.
4 Restore in new database.
5 Drop old database.
On Mon, Apr 6, 2009 at 9:50 PM, Shuly Avraham sh...@cshl.edu wrote:
Hi,
I need to rename a database having InnoDB tables.
MySQL version is:
Thank you everyone for your solutions.
I have found one, which may be of use to you.
It relies on the ability to rename a table from one database to another:
mysql rename table old_db.tabname to new_db.tabname
You would first need to drop all triggers, then recreate them.
So, I placed these
Hi,
I need to rename a database having InnoDB tables.
MySQL version is: 5.0.24-standard - so I cannot use the 'mysqladmin
rename' option.
What would be the best approach for doing this?
Thanks,
Shuly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To