Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I set up an environment for a developer with Windows server 2012, MySQL 5, IIS and ftp access and so on. We have a staging environment apart from the server environment. If I recall correctly, the dev was given the http://umbracosite url where the installer was waiting for him to proceed, and credentials for MySQL.
Somehow, it appears that he managed to avoid using MySQL at all; there is no other SQL server that I can find, and yet Umbraco seems to be functioning. There are two umbraco related databases in MySQL but they are completely empty with no tables. There is an AppData/umbraco.sdf that's about 4mb.
Where are the config files that configure database for Umbraco? This is not a WebMatrix install. I would like to figure out how Umbraco is accessing database and import the data into MySQL and reconfigure Umbraco to point to the new databases.
Thanks for any help,
Check the web.config and look at connection string. Maybe using the umbraco ce database. umbraco.sdf. you can use mysql but it will perform great with Microsoft SQLExpress which is free. Also to import the database you can use web matrix to an SQLexpress install. never done it to Mysql. I could but why?
Best of luck
Open the web.config file and search for connection string.
See the screen shot
hope this help
I think the developer has probably just hit the green "install" button and then Umbraco is installed with a predefined starter kit (Fanoe starter kit) based on CE SQL.
If one hits the "Customize" button in the install process one needs to make some choices regarding databases and whether to use a starter kit or not. During the DB selection it's stille possible to select CE SQL though but from your description above I'm 99% confident that he must have just hit the install button.
So you should probably do a migration from CE SQL to MySQL - Webmatrix might be useful for doing that.
Hope this helps.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted