Database backup of a mysql database in VB.Net?

You could invoke mysqldump, but you may need to be running your VB. NET on the Mysql server.

I found the easiest way was to use the mysqldump. Exe which is a standalone application. Mysqldump --host=HOSTNAME --user=USER --password=PASSWORD -R DATABASE NAME > PATH TO BACKUP FILE We had issues with backups not saving db functions but the -R switch sorted it so id recommend using it if you use stored procedures or functions in your DB.To restore the created file use the mysql command instead.

Mysql --host=HOSTNAME --user=USER --password=PASSWORD DATABASE NAME.

You can read each table's data and write it to a new database.

I would write a stored proc, since MySQL 5 has support for them, that handles all the data "heavy" work. Then just create scheduled task that calls the procedure every "night". For this latter component, I highly recommend Powershell....its awesome.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions