WebMatrix :: Force Webmatrix To Create MySQL Database Install Scripts On Local Box?
Nov 9, 2010
I've found a Webmatrix help article that says MS Webmatrix "publishes the (SQL Server or MySQL) database by creating scripts that run in a database that has been created for you by your hosting provider." That is wonderful, except I can't get it to work when I'm trying to publish a MySQL database (backing wordpress) through FTP (my hosting provider does not support 'web deploy'). Again, no problem, since it is already documented that " FTP protocols cannot be used to publish MySQL database. " But this does not excuse Webmatrix from generating MySQL database install scripts for me. During the publishing step, no database install script is generated - at least that I can tell - and there is no manual option to create a database export / backup / install script.
In short, as Webmatrix goes, I'm dead in the water trying to get my database uploaded to my hosting provider. Does anyone know the trick to force Webmatrix to create the MySQL database install scripts on my local box? Once created, I can take-over the upload and install process.
View 1 Replies
Similar Messages:
Feb 4, 2011
I downloaded WebMatrix thinking I could create a local Intranet page and simply host it from my server. Can I do this with WebMatrix? If so how?
View 1 Replies
Aug 25, 2010
when trying to install WordPress using WebMatrix I keep getting the following error: No connection could be made because the target machine actively refused it 127.0.0.1:3306 I added a port open rule in Windows Firewall, ran a Netstat -an with nothing showing up as using that port, and still no love.
View 4 Replies
Jan 19, 2011
I'm wondering if it is possible to include Microsoft.Data.Entity.CTP.dll reference to WebMatrix site and if the Compact edition of the database would support it? I'd kinda love use something like
code-first development in my WebMatrix project. I think is even easier than writing SQL-s into the code...
View 1 Replies
Mar 17, 2010
is there anyway i can connect to MySql through WebMatrix using asp.net
View 3 Replies
Dec 26, 2010
I try to create a wordpress site from the gallery and I get an error that says that it cannot find database. I dont have mySQL installed. I thought that WebMatrix would download and install it. Does WebMatrix Beta 3 expect MySQL to be installed? And if so, which version?
View 1 Replies
Oct 25, 2010
I started the Bakery site demo...everything runs fine on my local machine.When I publish the site to production server in w2k8r2+iis7.5 and with .net 4.0 (integrate) pool, my bakery apps not able to connect to the .sdf file.
Error I got is :
Connection string "bakery" was not found. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Connection string "bakery" was not found.
Source Error:
Line 2: Layout = "_SiteLayout.cshtml";
Line 3:
Line 4: FacebookSocialPlugins.Initialize("[xxx]", "[xxx]","bakery");
Line 5:
Line 6: }
Stack Trace:
[InvalidOperationException: Connection string "bakery" was not found.]
WebMatrix.Data.Database.OpenNamedConnection(String name, IConfigurationManager configurationManager) +132
WebMatrix.Data.Database.Open(String name) +42
System.Web.WebPages.DatabaseConnectionInfo.Connect() +43
System.Web.WebPages.SimpleMembershipProvider.CreateTablesIfNeeded() +42
System.Web.WebPages.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider sMembership, DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean createTables) +70
System.Web.WebPages.WebSecurity.InitializeProviders(DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +51
System.Web.WebPages.WebSecurity.InitializeDatabaseConnection(String connectionStringName, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +52
FacebookSocialPlugins.InitializeMembershipProviderIfNeeded() +54
FacebookSocialPlugins.Initialize(String appId, String appSecret, String membershipDbName) +171
ASP._PageStart_cshtml.Execute() in d:xxxakery\_PageStart.cshtml:4
System.Web.WebPages.StartPage.ExecutePageHierarchy() +15
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +33
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +207
View 2 Replies
Nov 22, 2010
I know we can use the HTML helpers, but how about the strongly typed one's?
Html.LabelFor()
View 1 Replies
Jan 11, 2011
I struggle with publishing 2 databases from WebMatrix using WebDeploy. On Publish settings screen I specify 2 different connection strings, but on Publish Compatibility screen Database names in both destination connection strings are equal. When I return to settings screen, original value is replaced there as well.
How destination server connection strings are evaluated? Here are connection strings from the root web.config file, which are set by hidden parameters in my parameters.xml:
<connectionStrings>
<add connectionString="Server=(local);Database=xxx;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
<add connectionString="Server=(local);Database=xxx2;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
</connectionStrings>
View 1 Replies
Jan 26, 2011
If I create two websites using the starter site template logging into one shows me logged into the other.
Here are the steps:
Create starter website called website1 Create starter website called website2 Run both websites in the same browser, firefox Register an account in website1 Log out of website1 Log back into website1 Refresh website2 and it shows my login name from website1 Has anyone else encountered this?
View 1 Replies
Aug 17, 2010
I'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I waswondering if someone knows a quick-fix?
View 12 Replies
Nov 8, 2010
I am trying to install SQL Server 2008 R2 by installing MS WebMatrix from web[URL].After Installation the WebMatix platform I tried to install the the SQL Server 2008 R2 but there is no new installation option
on SQL Server installation Center and I have "New Installation or add features to an existing installation" and the problem is when I click on this option installer prompts me to "Browse For SQL Server 2008 R2 Installation Media" As I mentioned I download the web platform from Microsoft/WebMatrix web page and I have not any installation media!
View 1 Replies
Dec 20, 2010
I just installed the WebMatrix Beta 3 on a machine and tried to create a site from web gallery. The site required MySql. MySql does not get installed so I looked at the install log files for WebMatrix and I see that WebMatrix is trying to download MySql from http://mysql.llarian.net/Downloads/MySQL-5.1/mysql-5.1.49-winx64.msi. The log indicates the return was 404. When I take a look at the llarian site, I no longer see this file available for download. The oldest file available is mysql-5.1.53-winx64.msi.
View 1 Replies
Mar 26, 2011
I get headeache from trying to install mysaql using WebMatrix in windows 7 home premium, it's installed fine, when i install Joomla , and starts new web stite , it dosnot connect to my sql, and i'm sure 200% from the username "root" and the password,,, is there problem in my windows,?
View 1 Replies
Jan 29, 2011
I have mysql 5.5 on my computer, but when I try to install joomla 1.6 the Web Platform installer does not recognise the mysql 5.5 database allready installed on my machine (os windows 7 64 bit). Instead it prompts me to download and install mysql 5.1.Am I doing something wrong? I this a bug or there is some incompatibility between webMatrix and my sql 5.5?
View 2 Replies
Feb 15, 2011
There I was, happily coding webpages, when suddenly it wouldn't run them anymore. Now when I click run I get an error message that looks like this: Server Error in '/' Application.This type of page is not served. Description:The type of page you have requested is not served because it has been explicitly forbidden. The extension '.cshtml' may be incorrect. Please review the URL below and make sure that it is spelled correctly.
Requested URL: /quiz/intro.cshtml
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
View 3 Replies
Feb 10, 2011
My hosting company states they support .net and razor. However after uploading my website made with webmatrix and razor *.cshtml pages. When i visit my website all i get is 404.17 error messages. As an testcase i decided to add an standard .aspx page. Visiting that page gives the same 404.17 error message :-(
.
According to my webhoster my web.config is wrong. However that one is generated by webmatrix. Besides my *.cshtml *.aspx a lot of files and directories are added to the bin folder. What can i check and what should my hosting provider check. When using the check compatibility the asp.net version is shown as unknown? My hosting provider claims my site is running asp.net 4.0 in integrated mode and that should be enough.
View 5 Replies
Jul 11, 2010
It's unfortunate that Microsoft WebMatrix (beta) doesn't recognize that files has been modified. I suggest you implement a feature similar to Visual Studio, allowing the user to decide what to do if the file has been modified outside WebMatrix. Especially when you have a button to launch the project in Visual Studio, it should have better support for "dual-development", cause at it is now, code can be overwritten by mistake easily.
View 3 Replies
Nov 13, 2010
I got the first beta of WebMatrix, downloaded Drupal, and got a site more or less going. I then tried to move it to two different hosts - first the IIS server running on my own domain controller, then to my hosting service. I dumped the DB with mysqldump, and imported it to the databases running on each server. Then I ftp'd the code and configuration files to both servers, and made appropriate configuration changes (primarily the mysql connect string).On both servers I have the same problem: The site comes up in its home page and looks great, but as soon as I log in as the site admin, I get a 404 (not found) error. Since it looks like virtually everything in Drupal is driven from the database, I really haven't the faintest idea where to start debugging this.
View 3 Replies
Sep 27, 2010
I am new to this new version of Webmatrix. I developed a couple of web sites on the previous version about 4 years ago.
I have downloaded and installed all of the recommended products using Microsoft Web Platform Installer including IIS Express, Web Matrix and Visual Studio 2010 Express.
1) I followed the Start From Scratch and set up the Hello World web site.
When I click on Run, if I am not online Internet Explorer opens but does not display the Hello World site.
If I am online and click on Run the Hello World site does display.
2) The new Webmatrix does not not have different tabs like the previous one did: Design & HTML & Code. To see the Design I launched Visual Studio 2010 Express but it still only shows me the code. In Tools/Options I have selected both Design view and Split View but both still only show me the code.
View 1 Replies
Aug 10, 2010
That subject may not do this questions justice.
I am trying to limit what I write on all my .cshtml pages. For example, on everypage I am @using myDLL and "connecting" to sql server.
I write that out like
@using System.myDLL;
@{
myDLL dll = new myDLL();
dll.ConnectionString = "blablabla";
}
How can I remove the need to do that to every single page? I think I can create a web.config and do some funky stuff... can someone show examples?
View 13 Replies
Dec 23, 2010
I am having all sorts of trouble with webmatrix hanging on me and was wondering if someone could test the following to see if it is isolated to me?
If I create a new empty site and add a single php page to it and then try to type the following line webmatrix will hand as soon as I get to the ? after src="
[Code]....
View 4 Replies
Feb 3, 2011
right now I playing around with WebMatrix and I followed the tutorial from http://www.asp.net/WebMatrix. Chapter 6 (displaying data in a grid) described how to use a WebGrid helper very clear, but the data in the example is always retrieved from an SQL DB.I want to use the same XML file from chapter 7 (Displaying data in a chart).Using the code:
...
var DataSet = new DataSet();
dataSet.ReadXmlSchema(Server.MapPath("/App_Data/QCFiler.xsd"));
[code]...
View 3 Replies
Mar 10, 2011
I am trying to publish a sugarcrm site I created in webmatrix to my site hosted on godaddy, however when i go into the publish settings and enter the server info, passwords etc., I can only get the connection to validate for the FTP protocol setting. When i click the button to test and validate the connection for webdeploy instead of ftp, it tries then says connection timed out. How do I get this to work so that I can publish my site on godaddy?
View 3 Replies
Mar 29, 2011
I met the same problem as follow link:http://stackoverflow.com/questions/5127284/is-this-a-bug-in-webmatrix-pagedataThe answer to this link is only available to "from a content page to a layout page", but I need "from a content page to a partial page", it still cause the problem.
View 4 Replies
