NissePPP
asked on
Backup and restore a mysql databse in vb.net
Hi!
Need som help to create a function that can backup and restore a mysqldatabase.
I have a mysql database on a windows xp machine, and I want to make a function in my vb.net
program that makes a backup of the database. And one function to restore the database.
I have heard that mysqldump works fine. but i need some help to make a vb.net function for this.
or in C# works fine to..
Need help.. plz.. :)
Thx
Need som help to create a function that can backup and restore a mysqldatabase.
I have a mysql database on a windows xp machine, and I want to make a function in my vb.net
program that makes a backup of the database. And one function to restore the database.
I have heard that mysqldump works fine. but i need some help to make a vb.net function for this.
or in C# works fine to..
Need help.. plz.. :)
Thx
What I did to make a function to backup and restore function in vb .net, I just a ran the console command from mysql to backup and restore a database. I have the code archived on my computer, I can try to find it and give you an exampe if this doesn't help.
ASKER
If you can find the code it will help alot
thx
thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will test this code.. if all works fine.. you will get the point..
thx m8
thx m8
Remember to replace root with your mysql username
ASKER
i haven' yet fulle tested the code.. but i belive it will work. so here are your point..
I got a another way to backup the datvase. via xml But the SQL script i got don't work. And I rellay dont know anything about SQL sctipt. Do you know anything abut SQL script. it would be noce to have more the one way to backup.
I got a another way to backup the datvase. via xml But the SQL script i got don't work. And I rellay dont know anything about SQL sctipt. Do you know anything abut SQL script. it would be noce to have more the one way to backup.
ASKER
Hmm, I'm not getting all the data from the databse. only the first row. is -u the onlu thing i should use
ASKER
sorry it works..