MySQL

Topics: ASP.NET 2.0
Apr 9, 2007 at 6:18 PM
Ok, I suggested this on the blog but it didnt' seem to post in the comments so i thought i'd ask here.

I really wanna use this since i much prefer asp.net over php and i like new things.

It would be great if there was a mysql DAL in this because i am maxed out on my hosting using sql server databases but have like 25 mysql ones avialable.

Would it be to hard to implement mysql support?
Coordinator
Apr 9, 2007 at 9:17 PM
We will be doing a provider model in the DAL soon. It is very easy to change the XML one to MySql, but it does take some time to testing. Basically, there are only 10 methods to be converted in order to make everything work - posts, categories and pages. If you can't wait for an official MySql provider, you should be able to create your own.
Coordinator
Apr 10, 2007 at 2:20 AM
You mention that you wanted to use MySQL because you are maxed out on SQL Server space. Using the native XML, you don't need any database server space. The XML is stored in your file space making it very easy in a hosted server environment.
Apr 10, 2007 at 4:58 AM
I have use xml backend blogs am not a fan of them because once you get to a certain point it really doesn't do to well performance wise compared to a database.
Jul 16, 2007 at 11:21 PM
Edited Jul 16, 2007 at 11:23 PM
Hi, I wanted a MySQL blog provider for my blog so I have implemented one this weekend.
This provider is based upon the new 1.1.0.0 release of the BlogEngine.Net.
I hope you will find some time to integrate this in the next release.
You can download the provider from my blog at http://www.rooijakkers.net/blog/
Keep up the good work ;-)




Jul 17, 2007 at 8:19 PM
I have updated my MySQL blog provider because I found 2 bugs.
One of these bugs is also present in the current MSSQLBlogProvider.cs file of BlogEngine.NET version 1.1.0.0!!

Fix: At line 106, The following line needs to be added: comment.Post = post;
If the postcomments are being retrieved for the 2nd time, no post is assigned to the Comments collection.
This causes the RecentComment list to raise an error.

The other bug did not update my ratings, but that was because I have updated my provider from version 1.0 to 1.1 the last moment.

So, my new version of the MySQL provider is updated and now available at http://www.rooijakkers.net/blog/


Nov 8, 2007 at 3:07 PM
I have created an expansion of BlogEngine.NET 1.2 that has support for MySQL. The MySQL support includes Roles, Membership, and all the tables currently supported in MS SQL BlogEngine.NET Database. If anybody is interested in checking it out. You can find the download at: http://www.codeplex.com/blog
Nov 24, 2007 at 9:55 PM


nberardi wrote:
I have created an expansion of BlogEngine.NET 1.2 that has support for MySQL. The MySQL support includes Roles, Membership, and all the tables currently supported in MS SQL BlogEngine.NET Database. If anybody is interested in checking it out. You can find the download at: http://www.codeplex.com/blog


I have upgraded to this version, but I can't figure out how to login initially. I tried username: admin, password: admin, but it did not work. Help?
Nov 25, 2007 at 12:18 AM
i figured it out: you need to go to yourblog/install/default.aspx

however, you need to modify the install.aspx file to get rid of the validator for the website, as it doesn't work correctly.

other things that need fixing: no way to manage posts, the reader needs to be closed in the LoadSettings() function (line 737) in the MySqlBlogProvider.cs, and the URL rewrite does not work at all. None of my permalinks or anything where there's rewriting works at all.

any help?