how to take backup of mysql database in asp.net

Question

hiii.. I have a mysql database. I want to take backup of database programatically in asp.net. Is is possible??? How??? Plz help me

Abhay Shanker · Answer

follow the steps of of below article.may be helpful to you http://www.c-sharpcorner.com/Blogs/14487/mysql-database-backup-restore.aspx

Ghanshyam Baravaliya · Answer

Hi try this sp and call this sp from backend ALTER PROCEDURE [dbo].[GetBackupDB] AS BEGIN DECLARE @BackupSQLScript nvarchar(max) DECLARE @SQLBackupFileName nvarchar(400) DECLARE @DatabaseName sysname DECLARE @SQLBackupFolder nvarchar(400) SET @DatabaseName = 'DB' SET @SQLBackupFolder = 'C:\' SET @SQLBackupFileName = @DatabaseName +'-'+REPLACE(REPLACE(Convert(VARCHAR,GETDATE()),' ','-'),':','-')+ '.bak' SET @BackupSQLScript = ' BACKUP DATABASE [' + @DatabaseName + '] TO DISK = ''' + @SQLBackupFolder + @SQLBackupFileName + ''' WITH INIT' print @BackupSQLScript EXEC sp_executesql @BackupSQLScript END if it help full than mark as answer

Raja T · Answer

Hi, Check out bellow URLs https://mysqlbackupnet.codeplex.com/ http://www.codeproject.com/Articles/256466/MySqlBackup-NET http://www.dotnetspider.com/resources/19537-MySQL-Database-Backup-Restore-from-C-NET.aspx

Ankit Shukla · Answer

Hi, Please check this link: https://mysqlbackupnet.codeplex.com/

how to take backup of mysql database in asp.net

Answers (4)