Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Single DB Backup

paul.avilespaul.aviles EntrantInactive User Role Beginner
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

Comments

  • scheryschery Entrant Inactive User Role Beginner
    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
  • gmousegmouse Mod Squad Inactive User Role Beginner
    What are "full individual daily backups"?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.