how do I copy tables between DBs?

[jacksonpt]

question is pretty straight forward... I recently moved my site to a new host and I have a few tables I want to copy from the DB on the old host to the DB on the new host. Any easy way to do it?

[devinemke]

are you using mySQL? if so use phpMyAdmin to export the db schema and then import to the new host.

[Sxooter]

If you're using pgsql, you can do this, from the command line:

pg_dump -t tablename dbname|psql dbname2