Diferencia entre revisiones de «MySQL»
De gacq wiki
(→=Hot backup - All databases) |
|||
| Línea 7: | Línea 7: | ||
=Scripts= | =Scripts= | ||
| − | ==Hot backup - All databases= | + | ==Hot backup - All databases== |
output="/srv/backup/mysql" | output="/srv/backup/mysql" | ||
fecha=`date +%F_%T | tr \: _` | fecha=`date +%F_%T | tr \: _` | ||
Revisión del 18:53 11 sep 2006
Tools
- PHPMyAdmin
Common task
Change password
set password = password("yournewpassword");
Scripts
Hot backup - All databases
output="/srv/backup/mysql"
fecha=`date +%F_%T | tr \: _`
cd $output
mysqldump --all-databases --password=elchinokavolvio > all-databases-${hoy}.sql
find $output -type f -name "all-databases.*.sql" -ctime 8 -exec rm -f {} \;
