1) What about 'copy to other' option' setp 1) create the target database 2) from the table menu 'copu tables to other databse or host' and here select what object you wnat to copy.
2) “Replace Database”. MySQL tried to introduce a “rename database” command in early 5.1. It failed (wiht stored program in particular) and they removed it again. We will not attempt to implemet client-side what the server does not support. It will only lead to problems. What SQL commands should we execute BTW? Please understand that SQLyog can only do what can be specified in SQL.
Basically I think that what you are requesting is a 'macro recording' option in SQLyog (creating a series of commands/operations as a single operation). We dont have any such plans.