Can't find the database

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
3/25/2011 4:11:24 AM
andydkelly
Gravatar
Total Posts 16
View Posts

Can't find the database

Hi there,

Can i begin by saying what a great system MojoPortal is. I am completely new to wed design (worked as an Infrastructure Manager for.

10 years) but am launching my own company and need a website! I have spent the last month developing my website locally on my laptop after installing mojoportal via the microsoft web app and am running it on WebMatrix. Not long after installing i moved my root folder to a second partition and this is where i have been working on it ever since. I am now ready to upload it to my hosting company HOWEVER i cannot find any databases anywhere so don't know how it is working. I have searched both my partitions for and .SDF files but can't find anything. Is there a place i can look to see where site is looking at for a database. I presume there must be one as it won't work without one?

I hope someone can help as i really want to launch my website on Sunday

Thanks

Andy

3/25/2011 4:18:52 AM
shirish
Gravatar
Total Posts 16
View Posts

Re: Can't find the database

Database will be created automatically.

You need to browse your site after deployment, it will create the database on it own, but before that you need to set connection string to point it to the current database.

Adter doing above setting, just browse http://yoursite/setup/default.aspx, and you will see it will run the scripts and install your site.

Thanks.

3/25/2011 5:00:11 AM
andydkelly
Gravatar
Total Posts 16
View Posts

Re: Can't find the database

Thanks Shirish.

However i currently have the site locally running on localhost:41392 and i have no database that i can find. Does this mean that whilst i have been developing there has been no database but when i deploy everything will be migrated into the database i create?

Apologies but i am VERY new to web design and publishing.

Thanks

Andy 

3/25/2011 5:20:14 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Can't find the database

Hi Andy,

mojoPortal supports several different flavors of database, my guess is you are using the one from the web app gallery which is using Microsoft SQL Server. You can confirm it by going to Administration > System Information in your site.

Probably you installed the whole shebang with the platform installer or directly with WebMatrix and it installed all the needed dependencies such as SQL Server Express. The database for SQL server does exist on disk (usually somewhere under Programs Files/Microsoft SQL Server) but its not as simple as just copying a file to move a site and its data. You would need to copy all the web files up to the host, but for the database you would have to create a backup using the SQL Management Studio and then you would restore the backup on the host and may even need to get help from the hosting company because after restoring the database on a new server the sql user gets orphaned and has to be re-created or re-attached.

The Platform Installer may not have installed the SQL Express management tools but if not you should be able to go back into platform installer and install it.

I'm not all that familiar yet with WebMatrix, it may have tools built in for managing the database so you may be able to create a backup from there. It may have a way to publish the site and the database together, but I have a feeling you're going to need the help of someone more technical to move your site to hosting.

See also Moving an Installation of mojoPortal to a Different Server.

Hope it helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.