Alrighty. I'm pretty n00b with SSH, so what I'm wanting to do is copy certain tables from a DB, and restore them to another database where these table names already exist.
Eg.
I want to dump:
DB1_USERS
DB1_POSTS
And a few more.
And I want restore them to:
DB2_USERS
DB2_POSTS etc.
Those tables exist already, so I don't want to lose that data.
How do I do this in SSH. Can someone give me the commands please? I'll be using root.
Edit: If a mod could change my type sump to dump, that would be super.
Question
Nashy
Alrighty. I'm pretty n00b with SSH, so what I'm wanting to do is copy certain tables from a DB, and restore them to another database where these table names already exist.
Eg.
I want to dump:
DB1_USERS
DB1_POSTS
And a few more.
And I want restore them to:
DB2_USERS
DB2_POSTS etc.
Those tables exist already, so I don't want to lose that data.
How do I do this in SSH. Can someone give me the commands please? I'll be using root.
Edit: If a mod could change my type sump to dump, that would be super.
Link to comment
Share on other sites
7 answers to this question
Recommended Posts