backup and restore odbc mysql tables

[ellenr]

My Access 2010 FE uses odbc mysql on a remote host as BE. I connect using dsnless connection. Is there a way to backup and restore tables in vba? I know how to connect to the host through cpanel and export to a sql file, but want to be able to click a button and accomplish the same. That way, when time comes to turn over the program to a non-programmer, backups (and restores, if needed) can continue.

 

[Ranman256]

i run make table queries to my access db. This is my backup.
If needed I can export the tables to MySql.

 

[ellenr]

Thank you for your reply. Would you mind posting the code you use to restore your odbc mysql tables from the local copy?

 

[Ranman256]

I had to leave that db with the employer, but it was just an append query from access to the odbc tbls.