In my application, I've a database(e.g. MyDataBase) in MySql Server. Lets assume that MyDatabase contains 5 table and each table has updated wit some data. Now i want to create a duplicate database with name MyDataBase1, duplicate of MyDatabase, which will contain same table and data as MyDataBase. How can i do this?
Thank you all in advance.