Capistrano i backup bazy
Posted by admin | Filed under Uncategorized
Backup produkcyjnej bazy danych za pomoca capistrano:
Kod:
Przykład działania:
$ cap mysql:backup
* executing `mysql:backup'
* executing "cat /var/www/apps/blogmd6/current/config/database.yml"
servers: ["md6.org"]
[md6.org] executing command
command finished
* executing "mysqldump -u puszek -p blog | bzip2 -c > blogmd6.dump.2008-05-20_23:24:32.sql.bz2"
servers: ["md6.org"]
[md6.org] executing command
command finished
servers: ["md6.org"]
** scp download blogmd6.dump.2008-05-20_23:24:32.sql.bz2 -> backups/blogmd6.dump.2008-05-20_23:24:32.sql.bz2
[md6.org] backups/blogmd6.dump.2008-05-20_23:24:32.sql.bz2
* scp download complete
* executing "rm blogmd6.dump.2008-05-20_23:24:32.sql.bz2"
servers: ["md6.org"]
[md6.org] executing command
command finished
Backup bazy znajdziemy w *backups/blogmd6.dump.2008-05-20_23:24:32.sql.bz2*
Tags: backup, capistrano, mysql