How to move special tables from one db to another by SSH

[cookie]

Guys Does any body know how to Copy or move some tables
from one database to another using SSH?

for example all tables witch start with prefix

tablename_

I know I can do it by phpmyadmin but I need to use SSH

Any body knows the command

Thanks

 

[khiltd]

SSH doesn't know anything about databases, you need to use the tools your RDBMS provides. Assuming you're talking about mySQL, that would be mysqldump or mysqlhotcopy, and there should be thousands of Google-able examples of how to use them. Here's the first one I found:

http://www.modwest.com/help/kb6-54.html