Backup all databases in MySQL
|
1 2 3 |
#!/bin/sh today=`date +%y-%m-%d-%H`; mysqldump -h localhost -u user -pass --all-databases | gzip > /home/backups/bd$today.sql.gz ; |
Backup a database and ignore tables
|
1 2 3 4 5 |
#!/bin/sh today=`date +%y-%m-%d-%H`; mysqldump -h localhost -u user -pass --single-transaction \ --ignore-table=database.sessions \ database | gzip > /home/backups/bd$today.sql.gz ; |