this worked for me:
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using MySql.Data.MySqlClient;
namespace ConsoleApplication1
{
class Program
{
string sqlStr = "";
static void Main(string[] args)
{
Program prg = new Program();
prg.CreateDatabase();
}
void CreateDatabase()
{
using (StreamReader reader = new StreamReader(@"C:\Users\Jamie\Desktop\Temp\localhost.sql"))
{
sqlStr = reader.ReadToEnd();
}
MySqlConnectionStringBuilder cnxBldr = new MySqlConnectionStringBuilder();
cnxBldr.Server = "192.168.27.5";
cnxBldr.UserID = "admin";
cnxBldr.Password = "password";
using (MySqlConnection cnx = new MySqlConnection(cnxBldr.ToString()))
{
cnx.Open();
using (MySqlCommand sqlCmd = new MySqlCommand(sqlStr, cnx))
{
int result = sqlCmd.ExecuteNonQuery();
}
}
}
}
}