Wonder if its possible

[Arcotemple:)]

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?

[I<3tanelipe]

I bet it can. WHY DONT YOU TRY IT!! xD

[Arcotemple:)]

lol cuz idk how i would go about trying stuff like that

[_Emme_]

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);

}

Found the script @ google.

[Arcotemple:)]

thanks emme you r 1337!