Restore and Backup from within Visual Basic

[Williams Castillo]

Hello,

I'm looking for a way to export and import my database from within Visual Basic in order to keep up to date to different sites (office and home).

I'm using the MyODBC driver for connectivity.

Currently, I must backup the database using a MySQL front-end application and then restore it in the other site using another MySQL front-end (actually, the same application, which is installed in both sites).

I'm about to do it manually, backing up each table and record, and then creating and filling them in the other side... but I'm a bit affraid of messing the whole thing up given the constraints, foreign keys and all that magical little things that make my life easier...

If there any open source library out there?? Or anything I didn't know of yet?

Thanks in advance,
Will