You can create 2 procedures in your service, one for backing up, and the other for restoring. To back up you need to make use of the MySQL
SELECT .... INTO OUTFILE
query syntax (just remember that you have no control of where the mysql server dumps this file, and that you can only backup one table at a time). Then to restore you need to use the
LOAD DATA INFILE
query syntax. I leave it up to you to google the correct way to use these queries. Personally, I created two classes that backup and restore MySQL databases completely. I have written an article about it on CP,
MYSQL Backup Utility[
^]. I then use these classes to backup and restore from my WCF service. If you need any help trying to get it to work over your service, just reply on the forum below the article, and I will try and help as much as I can.
Hope this helps