public void createLogFile(DBinfo dbconnstring)
{
string connString = @"server=" + dbconnstring.ServerName + ";userid=root" + ";password=metalic";
cnnLog = new MySqlConnection(connString);
string db;
try
{
cnnLog.Open();
}
catch (MySqlException ex)
{
MessageBox.Show("Can not open connection ! \n" + ex.ToString());
}
cmd.Connection = cnnLog;
/*if (db == null)
* {
* db = dbconnstring.DBName.Replace("_data", "");
* }
* else
* {*/
db = dbconnstring.DBName;
db = db.Replace("_data", "");
//}
cmd.CommandText = "CREATE DATABASE IF NOT EXISTS " + db + "_log";
try
{
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show("\n" + ex.ToString());
}
cmd.CommandText = "USE " + db + "_log;";
try
{
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show("\n" + ex.ToString());
}
string path = Path.GetDirectoryName(Application.ExecutablePath);
//path = path.Replace(@"bin\Debug", "");
MySqlScript script = new MySqlScript(cnnLog, File.ReadAllText(path + "\\SQLLOG2203.sql"));
script.Delimiter = "***";
script.Execute();
}
public string getConnectionString(DBinfo dbconnstring)
{
return("Data Source=" + dbconnstring.ServerName + ";Initial Catalog=" + dbconnstring.DBName + ";User ID=root" + ";Password=metalic");
}