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

Discussion in 'Linux VPS/Dedicated - General' started by cookie, Oct 6, 2007.

  1. cookie

    cookie Alien

    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
     
  2. khiltd

    khiltd New Member

    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
     

Share This Page