I am using MySql 5.1 Database.

I have created a Project database. (Template Database)

and want to Create a copy of the same database from the Application, every time, User Creates A new Project.

How can I copy and Create a New Database of same structure?

What is the Command to do so?

If you only want to copy the table structure etc. from one db to the other you can use this single bash line:

The new database must exist already. The -d flag in the mysqldump command prevents copying of data.

Dump the database with the -d option.

To create a new copy, do a "create database new-database-name; use new-data-base-name;", then run the dump file as a sql script.

Check out the SHOW CREATE TABLE command: https://dev.mysql.com/doc/refman/5.0/en/show-create-table.html It will return the create command used to create the given table.