On Mon, Nov 10, 2014 at 8:25 PM, Rodrigo Pichiñual Norin rodrigo.pichinual@gmail.com wrote:
Hi all.
I usally make backups of databases mysql.
I make buckups of all datbase for example:
mysqldump -u user -ppassword name_db > backups.sql
also I make backups just its schema for example
mysqldump -u user -ppassword name_db --no-data > backups.sql
Hola,
If size's a concern, just export your DBs gziped :
mysqldump -u user database | gzip > backup_database.sql
Also if you are concerned about time to compress, you can enable multithreaded parallel gzip compress with pigz (available in EPEL) :
mysqldump -u user database | pigz > backup_database.sql
TBH, 500 MB databases aren't big enough to seek a more complex approach (unless you have more ambitious RTO/RPO requirements)
HTH