How do i integrate the contents of one table into another in mysql?

We have a web site that owns on wordpress.I altered hosts not too long ago so pondered to can a repository restore on the new sponsor.However we noticed that some of the tables haven’t much been renewed properly.I want to know if we have a way in which i might restore individuals specific tables without overwriting files.(just fit what continues to be missed).I am a comprehensive newbie in this matter.Another person please help.

If a few of your dining tables have connection between the other person, then this backup file could not restore correctly.Then you should copy the actual create and also insert SQL from a backup file and execute it on your own.But try to remember it, you ought to execute the particular SQL to get first table which can be parent after which you can child step by step.

Try any query like:

place into table1 values(select * via table2).