Export tables from one database to another

Hello Friends,

I am trying to export few tables from one database to another. Both databases have same columns structure. I don't understand how to set the settings of Database(s), Table(s) and Data. I want to keep the original data of the target database unchanged. Thank you for your time.

Regards Mirish

• Database(s) are greyed out here as you selected "Database: xyz" as output. The checkboxes for "Database(s)" would otherwise generate a CREATE DATABASE xyz query.
• Table(s) should be created unless you know the structure is up to date in the target database
• Data should be "Insert" if you want to keep the existing data untouched. Even better: "Insert ignore", as this prevents errors in case there are rows matching to the source database.

Hello, Still I have the problem. The new database completely replaces target database. Also I can't select the tables from new database which I really want to export. Here are my settings.

Also I can't select the tables from new database which I really want to export.

You have probably by accident minimized the left sidebar on that dialog, which shows databases and tables. See the screenshot how that looks like normally:

No, I can see all of the tables but I can't do multiple selection on the tables. I can right click on one of the table and click on 'Export data as SQL' but same time can not select other tables. I don't understand which settings I have to modified. Thank you.

As told above: try to widen the left are on the export dialog.

Since I have no email address of yours, I am communicating through this forum. I want to donate, but my country name is not included in the Paypal list (Pakistan) and I cannot transfer through bank, so how do I make payment please ?

Sorry, if both ways are not possible, I have no other alternative.