From: Johan De Meersman Date: October 21 2011 8:46am Subject: Re: How to dynamically create database and tables on mysql? List-Archive: http://lists.mysql.com/mysql/226147 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Reindl Harald" > > create database, drop database > create table, drop table > create table like..... I suspect the table names and structures are going to be identical each time - I'm thinking automated blog deployment or something. Prepare by creating a database (say, template) manually and setting it exactly as it should be. Then, dump it so: # mysqldump --opt --routines --triggers --hex-blob template | bzip2 > template.sql Now you have a databaseless dump. Whenever you want to create a new database, you simply enter mysql: mysql> create database newsite; mysql> use newsite mysql> source /path/to/template.sql -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel