I have created an application using VB.Net but my major problems is in backup and restore. I used to copy the entire folder called data in the path where I installed the database. But when I copy that to another computer or on a fresh installation, all the tables will not work. Almost all my tables are Innob and cannot be use backup to command as I got from Mysql which only work on MyISAM.
I use MYSQL GUI that used to export it as .SQl for me but that is not what I need, I need to control it using my Vb.net
Plz can somebody help me out on the code I should use to backup to any drive and restore it back thanks and God bless.
I use MYSQL GUI that used to export it as .SQl for me but that is not what I need, I need to control it using my Vb.net
Plz can somebody help me out on the code I should use to backup to any drive and restore it back thanks and God bless.