I have created a couple of Umbraco sites before and think its great. But now I am looking at the templates and skins and see some potential for them, but my question is, when I apply a templace it creates lots of classes in the database... is there an easy way to clean them out and try a new template? I can see that I can delete them one by one, but I wondered if there was a way to just re-create a brand new fresh database?
I did consider just dropping the database in MySQL but I wondered if there is a sweeter way of just restarting with a virgin database?
Me thinks it's best to backup a db after you've performed a clean umbraco install, so you'll always have a *blank* (ie non populated db) at your disposal. But then again, it should only take a couple of minutes to set up a working clean umbraco site from scratch.
We have a database backup of a fresh/baseline install that we just use to restore the database when we're setting up/testing sites.
One thing to watch out for is if you have cutom datatypes that create new tables in the database, make sure those tables etc are included in the backup, or you'll lose them when you restore the database!
Getting a clean database
Hi,
I have created a couple of Umbraco sites before and think its great. But now I am looking at the templates and skins and see some potential for them, but my question is, when I apply a templace it creates lots of classes in the database... is there an easy way to clean them out and try a new template? I can see that I can delete them one by one, but I wondered if there was a way to just re-create a brand new fresh database?
I did consider just dropping the database in MySQL but I wondered if there is a sweeter way of just restarting with a virgin database?
Thanks Tony
Hi Tony,
Me thinks it's best to backup a db after you've performed a clean umbraco install, so you'll always have a *blank* (ie non populated db) at your disposal. But then again, it should only take a couple of minutes to set up a working clean umbraco site from scratch.
Cheers,
/Dirk
We have a database backup of a fresh/baseline install that we just use to restore the database when we're setting up/testing sites.
One thing to watch out for is if you have cutom datatypes that create new tables in the database, make sure those tables etc are included in the backup, or you'll lose them when you restore the database!
You might also want to look at http://our.umbraco.org/projects/developer-tools/usitebuilder
Rich
is working on a reply...