Logan wanted a way to move one table from a MySQL database to another database on a separate server. We found this idea in a closed discussion on Stack Overflow
mysqldump -u user dbname tablename -p > tablename_dump.sql
The thing that I thought was really cool and that I didn’t know before (‘cos I didn’t read enough of the manual) was that you can put a single table name after the database name and just get the structure and data for that table. You could then use that to send the new table and its data to your new database. In fact, the guy that posted it actually put it like this…
mysqldump -u username yourpass dbname tablename -p | mysql -u user secondDB -p
…which I haven’t used, but looks like a really neat way to do it.
Original Stack Overflow thread: http://stackoverflow.com/questions/15558461/move-table-from-one-database-to-another-in-mysql