MySQL - Historial de revisiones

Gacq en 12:05 21 oct 2010

2010-10-21T12:05:19Z

2008-10-27T15:19:31Z

‎Selected databases

2008-10-27T15:19:18Z

‎Hot backup - All databases, each database in a separated file

2008-07-08T15:15:06Z

Added links on backups using LVM snapshots

2007-11-03T11:38:45Z

‎Hot backup - One database

2007-04-17T20:07:28Z

‎Scripts

2006-12-01T21:17:51Z

‎Performance

2006-10-23T20:34:51Z

‎Performance

2006-10-23T19:54:44Z

‎Tools

2006-10-23T19:53:56Z

‎Tools

← Revisión anterior		Revisión del 12:05 21 oct 2010
Línea 100:		Línea 100:
	*[http://mike.kruckenberg.com/archives/2006/05/mysql_backups_u.html MySQL Backups using LVM Snapshots]		*[http://mike.kruckenberg.com/archives/2006/05/mysql_backups_u.html MySQL Backups using LVM Snapshots]
	*[http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ Using LVM for MySQL Backup and Replication Setup]		*[http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ Using LVM for MySQL Backup and Replication Setup]
		+
		+	= Errors =
		+	== Error 1044 on mysqldump ==
		+	<pre>
		+	mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
		+	</pre>
		+
		+	Resolved using the '--single-transaction' option of mysqldump
		+
		+	* http://forums.mysql.com/read.php?10,108835,112951#msg-112951

@@ Línea 93: / Línea 93: @@
   for db in `echo $databases`
   do
-    mysqldump -uroot -p$passwd $db | gzip > $dir/mySQL/mySQLdump-$db.dump.gz
+    mysqldump --databases  -uroot -p$passwd $db | gzip > $dir/mySQL/mySQLdump-$db.dump.gz
   done

@@ Línea 83: / Línea 83: @@
   for db in `echo $databases`
   do
-    mysqldump --password=$PASSWORD $db | gzip > $OUTPUTDIR/mySQLdump-$db-${date}.sql.gz
+    mysqldump --databases --password=$PASSWORD $db | gzip > $OUTPUTDIR/mySQLdump-$db-${date}.sql.gz
   done
   # Delete older backups
   find $BASEDIR -type d -name "mySQLbackup*" -ctime $DAYS -exec rm -fr {} \;
 ==Selected databases==

@@ Línea 26: / Línea 26: @@
   set password = password("yournewpassword");
-=Scripts=
+=Database Backups=
 ==Hot backup - One database==
 <pre>
@@ Línea 96: / Línea 96: @@
     mysqldump -uroot -p$passwd $db | gzip > $dir/mySQL/mySQLdump-$db.dump.gz
   done

@@ Línea 28: / Línea 28: @@
 =Scripts=
 ==Hot backup - One database==
- #!/bin/sh
+<pre>
- # by gacq
+#!/bin/sh
 # by gacq
- PASSWORD=$1
- DATABASE=$2
+USERNAME=$1
- OUTPUTDIR="/srv/backup/mysql"
+PASSWORD=$2
+DATABASE=$3
- # Delete backups older than the number of days specified in DAYS
+OUTPUTDIR="/srv/backup/mysql"
- DAYS=8
 # Delete backups older than the number of days specified in DAYS
- date=`date +%F_%T | tr \: _`
+DAYS=8
- mysqldump --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/$DATABASE-${date}.sql.gz
 date=`date +%F_%T | tr \: _`
- # Delete older backups
+mysqldump --user=$USERNAME --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/dbbackup_$DATABASE-${date}.sql.gz
- find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;
 ==Hot backup - All databases==

@@ Línea 13: / Línea 13: @@
 *[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]
 =Integration=

@@ Línea 5: / Línea 5: @@
 =Tools=
 *PHPMyAdmin
 *[http://www.xaprb.com/innotop innotop]
 **[http://www.xaprb.com/blog/2006/07/02/innotop-mysql-innodb-monitor/ innotop Article]