About
Profile picture Gokhan Demir,
a computer geek in Istanbul.

E-mail me Send mail


Photo Of The Day


  • Island at Twilight, South Africa, 2003

Calendar

<<  August 2008  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

Pages


    Recent posts


    Recent comments


    Archive


    Authors


    Tags


    Categories


    Blogroll


    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2008

    Sign in

    MySql Blog Provider For BlogEngine.NET

    by Gokhan Demir 12/10/2007 10:52:00 AM

    I'm using MySql server for the BlogEngine.NET back-end. Current version of the BlogEngine.NET supports XML and MS SQL as data storages. But my hosting plan has a limited option for MS SQL databases so i don't want to use it. And XML data provider option saves every post to individual files. Also i have some performance concerns about XML data storages. So i decide to use MySql. It's not very populer in ASP.Net community. But if you give it a chance, you will see how powerful and portable it is. I'm using MySql Connector/Net version 1.0, cause latest version of the connector has some trust level problems on Godaddy. Here are the steps that you need to follow for MySql data provider integration. (I'm assuming you're using BlogEngine.NET 1.2.x.x)

    - Create a database and change connection string on the sql.config file.
       Download MySql Script (2.43 kb)

    <connectionStrings>
    <add name="BlogEngine" 
    connectionString="Server=localhost; 
    Port=3306; 
    Database=databasename;
    Uid=username;
    Pwd='password';"
    providerName="MySql.Data.MySqlClient" /> 
    </connectionStrings>
    



    - Add MySql Connector dll to BlogEngine.Core References
       Download MySql Connector (54.92 kb)





    - Add MYSQLBlogProvider.cs file to Providers folder which on the BlogEngine.Core project. Download MYSQLBlogProvider (4.16 kb)


     



    - Add MySql provider to BlogEngine's provider tag on the web.congfig file.



     That's all..You can press F5 and test it ;)

     

     

    Related posts

    Comments

    1/27/2008 4:44:23 PM

    MK

    There seem to be no mysql support for 1.3. Where can I download the 1.2 version?

    MK us

    1/27/2008 6:14:42 PM

    Gokhan Demir

    you can browse and download old releases of blogengine.net at codeplex.
    This is last release before 1.3 version :
    www.codeplex.com/.../DownloadSourceCode.aspx

    Gokhan Demir tr

    1/27/2008 6:26:42 PM

    MK

    Thank you! I was spending last few hours trying to modify the 1.2 MSSQL script to work with BlogEngine.NET 1.3. There seem to be changes. I compiled but few errors in `category` section of the code.

    I am going to try with the version you mentioned abov

    MK us

    Add comment


    (Will show your Gravatar icon)  

      Country flag





    Live preview

    8/28/2008 5:09:17 PM

    Powered by BlogEngine.NET
    Designed by FYFI, Adapted by Gokhan Demir