mysql dump

how import or export a database from localhost or other host

[ note :

Export

[root@cit146 Desktop]# mysqldump -u root -ppassword -h 192.168.1.88 -P4001 qadb_1 >88_qadb_1.sql

then we create a database in a particular instance......

import

[root@cit146 Desktop]#mysql -u root -ppassword -h 192.168.1.146 -P4001 qadb_2 <88_qadb_1.sql

ERROR 1031 (HY000) at line 4560: Table storage engine for 'event_summary_watchedchapter1' doesn't have this option

debugging
---------------

1) show create table event_summary_watchedchapter1; // to show internal structure

In this stucture Engine =federated table

so go to vim *.sql

delete(double time press d) dump process in the editor

2) second thought is federated table link to the unreachable host or unknown table

it is always known by status or show create table command