private string GetFileName() { string dir = GetDataDirectory(); string path = dir + _instrument.ToString() + "_" + CUtilTime.GeDateString(DateTime.Now).ToString() + ".dat"; return(path); }
static void Main(string[] args) { //upd 2018-04-22 if (args.Length < 1) { Console.WriteLine("Invalid arguments. Usage: "); Console.WriteLine("MySQLDumper DATABASE_NAME"); return; } string dbName = args[0]; Process proc = new Process(); ProcessStartInfo startInfo = new ProcessStartInfo(); string path = Environment.GetEnvironmentVariable("DB_BACKUPS_PATH"); string tm = CUtilTime.GeDateString(DateTime.Now); string dirName = String.Format("{0}\\{1}\\{2}\\{3}", path, DateTime.Now.Year.ToString("D4"), DateTime.Now.Month.ToString("D2"), tm); CUtil.CreateDirIfNotExist(dirName); if (Directory.Exists(dirName)) { Directory.CreateDirectory(dirName); } string tmCurrent = CUtilTime.GetDateTimeString(DateTime.Now); string fname = String.Format("{0}\\fulldump_{1}.sql", dirName, tmCurrent); startInfo.FileName = @"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"; startInfo.Arguments = String.Format(@"--user=root --password=profinvest --routines --complete-insert {0} --result-file {1}", dbName, fname); proc.StartInfo = startInfo; proc.Start(); }
/* * public string GetDirName_Isin_TF( EnmTF TF, DateTime dt) * { * return IsinDir + @"\" + TF.ToString(); * } * * public string GetDirName_Isin_TF_Date(EnmTF TF, DateTime dt) * { * return GetDirName_Isin_TF(TF, dt) + @"\" + CUtil.GeDateString(dt); * } * */ /*public string GetFileName(EnmTF TF, DateTime dt) * { * * return String.Format(@"{0}\{1}_{2}.xml", IsinDir, CUtilTime.GeDateString(dt), TF.ToString()); * * } */ public string GetFileName(string TF, DateTime dt) { return(String.Format(@"{0}\{1}_{2}.xml", IsinDir, CUtilTime.GeDateString(dt), TF)); }