I'm working with Umbraco since a couple of months and I configure it to work with the database it uses by default, that is stored into add_Data folder. The problem is now that that database is corrupted. I cannot use the information stored there and I have to start from scratch all the development (unless there is a way to reuse the pages i've created but until now I haven't found a solution to this problem).
So my main problem is how I create the structure of the database that umbraco uses? I mean, does anyone have a script to create the tables that it uses? I just need to reconfigure my web to point to that new database and start creating all my inner pages again. But I can´t do this because I don´t know how is the structure of the database. Can anyone help me?
The easiest way is to install a fresh umbraco site with the same version of what you're currently using. After that you can point your current site to the new database.
You may want to back up the new db so that you can easily restore it again if needed
What would happen if I use somebody's database creation script? I mean, in SQL Server 2008 you can make your own database creation script. It export it in a .sql format. Can I use one of those scripts to start a new database? If I can, can anyone send me the .sql file? (it should include all the information, indexes, sql functions, procedures, etc).
The sql creation script could work. I know older versions of Umbraco (v4) also have the script file somewhere in the source code. For v6 I don't have it.
I need a new Database for Umbraco
Hi!
I'm working with Umbraco since a couple of months and I configure it to work with the database it uses by default, that is stored into add_Data folder. The problem is now that that database is corrupted. I cannot use the information stored there and I have to start from scratch all the development (unless there is a way to reuse the pages i've created but until now I haven't found a solution to this problem).
So my main problem is how I create the structure of the database that umbraco uses? I mean, does anyone have a script to create the tables that it uses? I just need to reconfigure my web to point to that new database and start creating all my inner pages again. But I can´t do this because I don´t know how is the structure of the database. Can anyone help me?
Thanks in advance.
Hi,
The easiest way is to install a fresh umbraco site with the same version of what you're currently using. After that you can point your current site to the new database.
You may want to back up the new db so that you can easily restore it again if needed
If you look in the Umbraco v6 source code you can see a method called InitializeDatabaseSchema. I think that is what you need.
Jeroen
What would happen if I use somebody's database creation script? I mean, in SQL Server 2008 you can make your own database creation script. It export it in a .sql format. Can I use one of those scripts to start a new database? If I can, can anyone send me the .sql file? (it should include all the information, indexes, sql functions, procedures, etc).
Thanks in advance.
The sql creation script could work. I know older versions of Umbraco (v4) also have the script file somewhere in the source code. For v6 I don't have it.
Jeroen
How do I know what version I'm running?? I don't remember which one I installed.
Can you send me that script file you have for v4?? Just in case I have that version installed.
Thanks and regards.
You can check the version number in the web.config. It's the umbracoConfigurationStatus appSettings.
Jeroen
I'm using 6.0.3 version.
Where do you think I can get the database creation script for this version?
Thanks in advance.
Best regards.
is working on a reply...