EASY QUESTION. Reusing the same database

numerical25

Is it possible to duplicate a database. I was designing a website and using a database to create it. now that Im done with the website I want to empty everything out of the database or atleast make duplicate databases like that one so i can different websites with the same database. is that possible ??

sidsel

With phpmyadmin you can copy an entire database to a new one with a few mouseclicks if this is what you want to do.

numerical25

well, I dont want to exactly copy a database along with the data inside of it. just duplicate the database and its structure. Like the tables and everything. so i can reuse it to make a totally different website except with the same database.

Plus the mysql database server im using now is on my computer. i will i be able to transfer the database onto a another server when it comes time

NogDog

The SQL command SHOW CREATE TABLE table_name will output the SQL which can be used to recreate a given table structure.

If using phpMyAdmin, you can select the desired database, then select the "Export" tab. Select the "SQL" option in the "Export" section, leave the "Structure" option checked, but uncheck the "Data" option, then click "Go".

numerical25

So i cant show create DATABASE.

Does this mean that I gotta create a new database and show create each table into the database ???

And about the phpmyadmin. Was that for exporting a database to another database or something else

NogDog

numerical25 wrote:
So i cant show create DATABASE.

Does this mean that I gotta create a new database and show create each table into the database ???

And about the phpmyadmin. Was that for exporting a database to another database or something else

The phpMyAdmin thing will output all the SQL needed to recreate all the tables of the database. You can either let it print to the screen, then copy-and-paste it into a script or command line SQL interface; or you can save it to a .sql file and then read that file in via phpMyAdmin's import facility, or via MySQL command line, or whatever it is you want to do. You would have to first create the new database, then select it, then run the table creation SQL. (You could do a "show create database" if needed, changing the database name to the new database name before running it.)

Sxooter

you should be able to do it with mysql_dump ( I think that's the command)

Look up the switches

Roger_Ramjet

Or you could just try using the MySQL Migration Tool. Works pretty well with eg Access->MySQL, should be a breeze with mysql->mysql - just export the script to a file for reuse.

numerical25

So lets say if my database was called Mywebsite. to duplicate it, i would go into mysql and type in

SHOW CREATE mywebsite

which will duplicate the orginal database. Then I would have to rename it. and thats it ???