To make MySQL make an automatic backup everyday after like say every 30 minutes
then it saves to a certain folder in your comp
can it be done?
then it saves to a certain folder in your comp
can it be done?
Found the script @ google.Quote:
using System.Runtime.InteropServices;
[DllImport("kernel32.dll")]
static extern int GetShortPathName(string longPath, StringBuilder buffer, int bufferSize);
public void Batch()
{
StringBuilder buffer = new StringBuilder(256);
GetShortPathName(Path.GetDirectoryName(MySqlEXEPat h), buffer, buffer.Capacity);
string shortfilename = buffer.ToString();
string BatchFile = @"c:\temp\Batch.bat";
StreamWriter sw = new StreamWriter(BatchFile);
sw.WriteLine("cd " + shortfilename);
sw.WriteLine(@"mysql -uroot -pXXX DB_NAME < C:\TEMP\FILE.SQL");
sw.Flush();
sw.Close();
//IMPORTANT, DO NOT FORGOT THIS
Environment.CurrentDirectory = @"c:\windows\";
Process.Start(BatchFile);
}