MySQL
De gacq wiki
Contenido
Documentation
Tools
- PHPMyAdmin
- mytop
- mtop
- innotop
Performance
Syntax
Select
CONCAT(first_name, ' ', last_name)
Integration
Authentication using LDAP, kerberos, etc is not ready yet
Common task
Change password
set password = password("yournewpassword");
Scripts
Hot backup - All databases
#!/bin/sh # by gacq # # MySQL root password PASSWORD=$1 OUTPUTDIR="/srv/backup/mysql" # Delete backups older than the number of days specified in DAYS DAYS=8 date=`date +%F_%T | tr \: _` mysqldump --all-databases --password=$PASSWORD | gzip > $OUTPUTDIR/all-databases-${date}.sql.gz # Delete older backups find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;
Hot backup - One database
#!/bin/sh # by gacq # PASSWORD=$1 DATABASE=$2 OUTPUTDIR="/srv/backup/mysql" # Delete backups older than the number of days specified in DAYS DAYS=8 date=`date +%F_%T | tr \: _` mysqldump --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/$DATABASE-${date}.sql.gz # Delete older backups find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;
Selected databases
databases="db1 db2 db3" for db in `echo $databases` do mysqldump -uroot -p$passwd $db | gzip > $dir/mySQL/mySQLdump-$db.dump.gz done