now iam using mysql version 5.0.45.and the problm is,i want to take a dump of database. and it contains 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.
Asked
Active
Viewed 1,298 times
2
-
Do you want to restore you database? – Devart Jul 29 '11 at 12:54
1 Answers
2
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.
Devart
- 119,203
- 23
- 166
- 186