MySql - Running a complex script using the .net Connector

[The solution was discovered via this entry in the mysql.com forums]


If your MySql script contains code like

"/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;"

You'll need to add "Allow User Variables=true" to your connection string. This can be achieved by manually adding it to the string, or, if using a MySqlConnectionStringBuilder, something similar to the following:

var builder = new MySqlConnectionStringBuilder
{
   Database = database,
   Server = Server,
   Password = Password,
   UserID = Username
};
builder.Add("Allow User Variables", true);

Make sure you're using at least version 5.2.6 of the MySql Connector/Net though! The forum posting states that it works with 5.2.2, but it didn't work with the copy of 5.2.2 I hav, but did with 5.2.6.

Other useful links from the forums:

Re: How do i run a *.sql script from my c# environment?

About Rob

I've been interested in computing since the day my Dad purchased his first business PC (an Amstrad PC 1640 for anyone interested) which introduced me to MS-DOS batch programming and BASIC.

My skillset has matured somewhat since then, which you'll probably see from the posts here. You can read a bit more about me on the about page of the site, or check out some of the other posts on my areas of interest.

No Comments

Add a Comment