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 co
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 wrote:
> Hi,
>
> I need to rename a database having InnoDB tables.
> MySQL version is: 5.0.24-standard - s
hi,
I have a solution. Please my blog's http://www.fire9.cn/?p=132.
good luck.
-
Ding Hao/Fire9 DB Architect
Email&msn>alk: fire9di...@gmail.com
My Blog:http://www.fire9.cn
My Twitter: http://twitter.com/fire9
在 2009-4-7，上午12:20， Shu
