#Mysql backup database workbench how to#

is developed by Oracle Corporation, licensed under GPL License ().A reference of this DLL must be added into your project in order for to compile or work with MySqlBackup.NET.MySqlBackup.NET relies on the following component to work. Can be used directly in ASP.NET or web services.Able to export rows into different modes (Insert, Insert Ignore, Replace, On Duplicate Key Update, Update).Progress Report is Available for Both Export and Import Task.Conditional Rows Export (Filter Tables or Rows).As most web hosting providers forbid that, MySqlBackup.NET will be helpful in building a web-based (ASP.NET/Web-Services) backup tool. On the other hand, MySqlDump.exe cannot be used for Web applications. Using MySQL Workbench as a backup tool is not a suitable solution for client or end-user. MySQL Workbench is good for developers, but, when it comes to client or end-user, the recommended way is to get every parameter preset and all they need to know is press the big button ' Backup' and everything is done. The most common way to backup a MySQL Database is by using MySqlDump.exe and MySQL Workbench. We will have better control on the output result.

It is an alternative to MySqlDump.Īnother benefits of making this tool is, we don't have to rely on two small programs - MySqlDump.exe and MySql.exe to perform the backup and restore task.

#Mysql backup database workbench how to#

This article introduces a tool (DLL) that can backup/restore MySQL database in C# or VB.NET and some sample codes on how to use it.