private static bool RestaurarDatos(string archivo)
{
bool restaurarDatos = false;
List <string> credentials = UtilVarios.GetCredentialsDB();
string server = credentials[0];
string user = credentials[1];
string database = credentials[2];
string pass = credentials[3];
UtilDB.UnzipDB(archivo);
archivo = archivo.Substring(0, archivo.Length - 3);
UtilDB.RestoreDB(server, 3306, user, pass, database, archivo);
// compruebo si se restauraron los datos
Char delimiter = '_';
String[] substrings = archivo.Split(delimiter);
int pc = Convert.ToInt32(substrings[2].Substring(2));
string fecha = substrings[3].Substring(0, 10);
int registroRestaurado = DAL.DatosDAL.RegistroRestaurado(fecha, pc);
if (registroRestaurado > 0)
{
restaurarDatos = true;
}
return(restaurarDatos);
}
public static void ConfigurarMySQL()
{
List <string> credentials = UtilVarios.GetCredentialsDB();
string server = credentials[0];
string user = credentials[1];
string database = credentials[2];
string pass = credentials[3];
string pathMysql = string.Empty;
if (Directory.Exists(@"C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin"))
{
pathMysql = @"C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin";
}
else if (Directory.Exists(@"C:\Program Files\MySQL\MySQL Server 5.5\bin"))
{
pathMysql = @"C:\Program Files\MySQL\MySQL Server 5.5\bin";
}
else if (Directory.Exists(@"C:\Archivos de programa\MySQL\MySQL Server 5.5\bin"))
{
pathMysql = @"C:\Archivos de programa\MySQL\MySQL Server 5.5\bin";
}
else if (Directory.Exists(@"C:\Archivos de programa (x86)\MySQL\MySQL Server 5.5\bin"))
{
pathMysql = @"C:\Archivos de programa (x86)\MySQL\MySQL Server 5.5\bin";
}
Process process = new Process();
process.StartInfo.FileName = pathMysql + @"\mysqlinstanceconfig.exe";
string args = "-i -q ServiceName=MySQL ServerType=DEVELOPER DatabaseType=INODB Port=3306 Charset=utf8 RootPassword="******"\Mysql\mysql.exe";
// string filename = Application.StartupPath + @"\Mysql\ncsoftwa_re_install.sql";
string filename = Application.StartupPath + @"\Mysql\ncsoftwa_re.sql";
process = new Process();
process.StartInfo.FileName = pathEjecutable;
args = "-C -B --host=" + server + " -P 3306 --user="******" --password="******" -e \"\\. " + filename + "\"";
process.StartInfo.Arguments = args;
process.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
process.Start();
process.WaitForExit();
filename = Application.StartupPath + @"\Mysql\dump_admin.sql";
process = new Process();
process.StartInfo.FileName = pathEjecutable;
args = "-C -B --host=" + server + " -P 3306 --user="******" --password="******" -e \"\\. " + filename + "\"";
process.StartInfo.Arguments = args;
process.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
process.Start();
process.WaitForExit();
}
// EXPORTAR DATOS POS
public static void ExportarDatos()
{
credentials = UtilVarios.GetCredentialsDB();
server = credentials[0];
user = credentials[1];
database = credentials[2];
pass = credentials[3];
DataTable tbl = BL.GetDataBLL.RazonSocial();
idRazonSocial = tbl.Rows[0][0].ToString();
strFile = idRazonSocial + "_datos.sql";
UtilDB.DumpDatos(server, user, pass, database, @"c:\windows\temp\" + strFile);
if (ValidarDump())
{
if (File.Exists(@"c:\windows\temp\" + strFile + ".xz"))
{
File.Delete(@"c:\windows\temp\" + strFile + ".xz");
}
UtilDB.ZipDB(@"c:\windows\temp\" + strFile);
strFile = strFile + ".xz";
Reintentar:
UtilFTP.UploadFromFile(@"c:\windows\temp\" + strFile, "/datos/" + strFile);
UtilFTP.DownloadFile(@"c:\windows\temp\tmp_" + strFile, "/datos/" + strFile);
if (!UtilVarios.FileCompare(@"c:\windows\temp\tmp_" + strFile, @"c:\windows\temp\" + strFile))
{
if (intentosUpload < 5)
{
intentosUpload++;
goto Reintentar;
}
}
}
else
{
if (intentosDump < 5)
{
intentosDump++;
ExportarDatos();
}
}
intentosUpload = 0;
intentosDump = 0;
}