Tony
asked on
Ms Access mysql back up
I am using ms access as a front end for a mysql database. I need to back up the database from where the ms access engine is located...i mean from a pc that is not the server. How?
When you use a "real" RDBMS as the BE for Access, you should be using the tools provided with that RDBMS to manage the database.
You could have a supported backup routine installed on the server that could be called on demand.
Then, from your workstation, call that command.
Then, from your workstation, call that command.
Is the mysql running on Windows or Linux..?
ASKER
Mysql Run in Windows...
ASKER
Yes....I have an automatic schedule back up in the server. However, I would like for a user to be able to back up manually also, from the user pc.
Then, somehow, let your application send a command to the backup system to run an unscheduled backup.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent
You could write a proc to create a text file with the INSERT commands... yourself. Basically write your own function to create a dump file, but this would probably be a slow process compared to using a Cron Job (see below).
Why not simply create a Cron job on the Server to create the dump file on regular intervals and then you can use VBA to grab a copy using FTP code? Or your Cron Job could automatically FTP it somewhere or email it...