How can I make an automatic copy of a MySQL database to another MySQL database on the same server?
You can setup second mysql instance with replication. If you need to "copy" only during certain time period, you may choose to cron a script which will start and stop replication according to the time.
Again you can only choose to replicate-do-db certain databases as well.