I have a MySQL database that contains almost 100 tables.
I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to have the same schema/table structures as the original database.
Is there any way to automatically make N duplicates of the original database and set them up on N different ports?
Thanks