Single DB Backup

MySQL & MariaDB Other MySQL® Questions
1

I am not sure I am reading the information correctly or not.

Is it possible to perform full individual daily backups instead of an entire MySQL system?

Also, we backup to an EMC DataDomain unit which does some amazing inline deduplication, however one of the requirements is that the backup cannot be compressed so need to have the ability to do individual .tar files per database.

I read somewhere that this is not possible with Percona, can someone validate this?

Regards,

Paul

2

Hello,

For me, i beleive you can do it like this :
mysqldump -u login -ppassword your_schemas > /folder/your_schemas.sql
and replicate this for each of your schemas.
Like this you will have a backup file by schema.

regards

3

What are “full individual daily backups”?