Re: MYSQLDUMP: Export a table data and Import in a different table

[Rick James]

"similar structure"?

mysqldump works well if the structures are close enough. What are the differences?

I would probably do, instead,
INSERT INTO new_table (a,b,c)
SELECT a,b,c FROM old_table;

By using INSERT..SELECT, I could account for
* Different number of fields,
* Modifying the data for any field(s),
* Deal with incompatible datatypes,
* Rearrange the order of the fields,
* etc.

mysqldump probably cannot handle any of those differences in structure.