#MYSQL
Consider you have two databases: source_db and target_db. If you want to copy the database contents from source_db to target_db you should do as follow in HeidiSQL:
1. Right click on source_db then select: Export database as SQL.
2. Now change the value of Output and select Database.
3. A select box will appear, select target_db and that's all.
Source : https://stackoverflow.com/questions/1...