Hi,
I tried copying the database which already exists and contains 40 tables in it. I made it easily using development server and using phpMyAdmin.
Using phpMyAdmin, i acheived this easily by opening the database i want to copy and rename, using operations and "copy database to:" and giving the new database name and selecting "structure only" option and selecting three check box, Add AUTO_INCREMENT value, Add constraints, and swithch to copied database.
IS there any easiest way that i can do the same in production environment? If so how i can accomplish this?.
Please help me.
Thanks.
