How to copy XML to MySQL

Topics: Controls
Feb 24, 2012 at 5:04 AM

I wanna copy blog data on BlogEngine to MySQL, and I'm reading this webpage now.


I put 2 files (/admin/Pages/BlogMigration.aspx & /admin/Pages/BlogMigration.aspx.cs) on folder of my blog.

Although I tried to access http://localhost/admin/Pages/BlogMigration.aspx, my BlogEngine page showed the following message.

Ooops! I can't find the page you're looking for

You might find one of the following links useful:


If I access invalid URL, the web page showed 404 - File or directory not found.

I mean BlogEngine knows he has BlogMigration.aspx on his folder, but he doesn't wanna show me it now.

Must I update some files to access http://localhost/admin/Pages/BlogMigration.aspx?

Feb 24, 2012 at 2:29 PM

You can export your blog data and then import it into new blog.

Feb 24, 2012 at 4:04 PM

Thank you, rtur.

I will try it.

Feb 27, 2012 at 2:24 AM

I did it thanks to rtur's advice. Thank you very much.

Then I needed the following advice, too.



When you copy over the SQLServerWeb.config file to the root folder,
the initial <connectionStrings> section in that file looks like:

   <add name="LocalSqlServer" connectionString="dummy"/>
   <!-- Mono complains if LocalSqlServer isn't specified -->
   <add name="BlogEngine" connectionString="Data
Source=MySQLServer;User ID=user;Password=password;persist security
info=False;initial catalog=BlogEngine;"

You would want to change the "BlogEngine" connection string.

 - For the "Data Source", replace MySQLServer with,1750
 - For the "User ID", replace user with your SQL Server username.
 - For the "Password", replace password with your SQL Server password.
 - For the "initial catalog", replace BlogEngine with your SQL Server
database name.