Diferencia entre revisiones de «MySQL»
De gacq wiki
(→Tools) |
|||
| Línea 5: | Línea 5: | ||
==Change password== | ==Change password== | ||
set password = password("yournewpassword"); | 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 {} \; | ||
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 {} \;
