Test this first just to be safe.
mysqldump -uusername -ppassword -h yourMySQLHostname dbname tableA tableB tableC > output.sql
Note the table or tables follows the database name.
mysql -u dbuser -p -h dbhost.yoursite.com -D dbname < /path/to/backup.sql
The -D option is used to extract the tables data from the backup.sql you made in the backup process.
I have not used this for a long time so please try it out first in a test.
Opinions are my own views, not DreamHosts’.
I am NOT a DreamHost employee OK! :@
Act on my advice at your own risk!