This is probably the wrong place to be asking about database
backups... but this group goes off so:
I have a corporate client that wants their data backed up, and in
their hands. So, a full database backup and a promise isn't going to
cut it, and a full database backup in their hands is bad because we's
have to give them everyone elses data!
My first thought was to generate a bunch of CSV files... but the
database is quite complex and I'd need a separate file for each table.
That's fine I guess, but I'm curious if there is a better way?
Especially if the database often changes.
I'm using MySQL, so does anyone know if there are good tools out there
that can selectively backup data? can mysqldump do it? how? what about