MySQL, Cron

[mpyusko]

Is there a way i can cron the export of a particular MySQL table to Excel format. I'd like to have a copy of my memberships offline. Also, is there a way I can do it on-demand with a link, possibly in PHP?

[Jef S.]

I'm not sure about how Excel will handle MySQL dumps, being MS Office illiterate(proudly, I might add ) But you can cron mysqldump. Put in a ticket with your DB name, login, password, and what time you want it to happen and I'll set that up for you. Mysqldump can be a bit taxing on the server depending on the size of your DB, so we may have to find a time to do the dump that we can both agree on, but we'll cross that bridge as we come to it.

[mpyusko]

Ok, I just did.