开发者

how to take dump of mysql for federated table?

开发者 https://www.devze.com 2023-03-23 15:17 出处:网络
now iam using mysql version 5.0.45.and the problm is,i want to take a dump of database. and it contain开发者_运维知识库s federated tables also. wen i am taking dump, it is showing anerror \"ERROR 1031

now iam using mysql version 5.0.45.and the problm is,i want to take a dump of database. and it contain开发者_运维知识库s federated tables also. wen i am taking dump , it is showing an error "ERROR 1031 (HY000): Table storage engine for 'employee_details' doesn't have this option" . actually 'employee_details' table federated from another database. how to solve this problm.? advanced thanks.


Have a look at this page - http://bugs.mysql.com/bug.php?id=21360

Your dump script may have ALTER TABLE statements, but FEDERATED tables cannot be altered, it is a restriction. Try to restore your table without ALTER TABLE statements.

0

精彩评论

暂无评论...
验证码 换一张
取 消