Export data from one table and import it to another table
I have exported the table to a dump file. Then I scp the dump file to the other server. When I try to import it, it complains that the table name cannot be found in the export file. Can I not import data to a table with different table name?
What other ways can I achieve my objectives? Thanks.