MrWize | ASP.NET and MySQL programming
with Visual Web Developer

MySQLBlogProvider for BlogEngine.NET

January 19, 2008 14:26 by MrWize

For all interested in running BlogEngine.NET v1.3 with MySQL I release my MySQLBlogProvider + table-setup.sql including default settings.

Hope someone have some use for this provider.

After download extract the MySQLBlogProvider.cs into Your Provider-directory.

Open up the tool You use to edit your mysql-database with and execute the table-setup.sql script.

Open up web.config and make sure it looks like this:

  <BlogEngine>
    <blogProvider defaultProvider="MySQLBlogProvider">
      <providers>
        <add name="XmlBlogProvider" type="BlogEngine.Core.Providers.XmlBlogProvider, BlogEngine.Core"/>
        <add name="MSSQLBlogProvider" type="BlogEngine.Core.Providers.MSSQLBlogProvider, BlogEngine.Core"/>
        <add name="MySQLBlogProvider" type="BlogEngine.Core.Providers.MySQLBlogProvider, BlogEngine.Core"/>
      </providers>
    </blogProvider>
  </BlogEngine>

Bold part above are the changed/added things to the BlogEngine-configuration.  

The provider is tested under MySQL v4.0.xx and v5.0.xx 

MySQLBlogProvider.rar (5.04 kb)


Currently rated 4.2 by 5 people

  • Currently 4.2/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Related posts

Comments

January 30. 2008 13:23

Magnus Eriksson

Had some errors installing on webhotel (surftown.se), needed to make som changes to the code to use it.

First error in the sql script.
When create the settings table you use a lower-case character in the tablename "be_settings", it will not work when trying to insert settings into "be_Settings"

Second error i got when the server tried to read the tables created. I didnt find tables like "be_Settings" due to upper-case character. I made a change to the script and the code for the provider to use lower-case characters in the tablenames then work like a charm.

Thanks for the MySqlProvider
Mysql gave errors on the table names

Magnus Eriksson

March 5. 2008 04:26

troy

Nice add-on! One small glare I've noticed on my hosting provider is that mysql columns seem to be case sensitive so if they tablenames aren't named lie those hardcoded in the codebase... you get errors... small issue, easily fixable without modifying code!!

troy

March 13. 2008 17:58

Dr MHQ

hi
I'm trying to get my blog running on MySQL but the problem is that it is taking it long time trying to load the page but nothing happens !!!
one more thing I have modified at the connection string which is the provider I used MySql provider instead of MSSQL
any clue why am I getting the strange behavior ?

Dr MHQ

March 29. 2008 08:17

megaupload links

Thanks

megaupload links

April 1. 2008 18:44

Peru-guia

This site is very cool,
your information is precious.
I'm peruvian. Visit my country.
My website is working with php and mysql.

Peru-guia

April 14. 2008 21:21

pingback

Pingback from hockblogs.net

Major Blogengine.NET security issue and fix with MySQL provider

hockblogs.net

April 23. 2008 18:02

Codes Web

thanks you

Codes Web

April 23. 2008 18:02

Codes Web

thanks you

Codes Web

April 30. 2008 00:14

andre

Ah! that's what I was looking for!
thanks for posting! =)

andre

May 8. 2008 13:22

Andre Tagesgeld

Hi,
thanks, very nice. But why shall I use MySQL? Do you have problems using the xml-based storage on blogs with high traffic? Till today I never ran into any performance-trouble.

Andre Tagesgeld

June 14. 2008 07:13

Bolsa de Trabajo

Interesting information thanks.

Bolsa de Trabajo

June 14. 2008 07:15

Bolsa de Trabajo

Interesting.

Bolsa de Trabajo

June 14. 2008 07:22

Bolsa de Trabajo

Thanks.

Bolsa de Trabajo

July 8. 2008 08:04

Fredrik Berggren

Hej, jag kan inte få kommentarerna att fungera med MySql och BE, något du upplevt ?

Fredrik Berggren

July 30. 2008 12:29

Perok

Really usefull

Perok

August 7. 2008 10:21

MrWize

Nej, inget jag upplevt

/Patrik
a.k.a MrWize

MrWize

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

September 3. 2010 12:24