Diferencia entre revisiones de «MySQL»

De gacq wiki
Saltar a: navegación, buscar
(Performance)
(Performance)
Línea 13: Línea 13:
 
*[http://www.mysqlperformanceblog.com MySQL Performance Blog]
 
*[http://www.mysqlperformanceblog.com MySQL Performance Blog]
 
**[http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ What to tune in MySQL Server after installation]
 
**[http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ What to tune in MySQL Server after installation]
 +
 +
=Syntax=
 +
==Select==
 +
CONCAT(first_name, ' ', last_name)
  
 
=Integration=
 
=Integration=

Revisión del 18:17 1 dic 2006

Documentation

Tools

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