PM> Install-Package MySqlBackup.NET
Kode backup ke mysql, bisa di taruh di dalam kelas :
public void Backup()
{
string constring = "server=localhost;user=root;pwd=root;database=dataku;";
string file = "D:\\backup.sql";
using (MySqlConnection conn = new MySqlConnection(constring))
{
using (MySqlCommand cmd = new MySqlCommand())
{
using (MySqlBackup mb = new MySqlBackup(cmd))
{
cmd.Connection = conn;
conn.Open();
mb.ExportToFile(file);
conn.Close();
}
}
}
}
lalu, untuk perintah restore sebagai berikut :
public void Restore()
{
string constring = "server=localhost;user=root;pwd=root;database=dataku;";
string file = "D:\\backup.sql";
using (MySqlConnection conn = new MySqlConnection(constring))
{
using (MySqlCommand cmd = new MySqlCommand())
{
using (MySqlBackup mb = new MySqlBackup(cmd))
{
cmd.Connection = conn;
conn.Open();
mb.ImportFromFile(file);
conn.Close();
}
}
}
}
No comments
Post a Comment