I have a full dump from database A. I want to import only the data of this dump into database B. Database B's structure is the same as database A only it misses some tables. How can I do this?
The reason that I don't import the full dump and delete the extra tables is that database B is on RDS and when I import the dump file into it, the importing job will stop in the middle of it. I tried three times and the database is quite large. Every three times, it stops at the same place. RDS log is not showing anything. So I decided to only import the data from the dump file.