From 3a8613ab9d7235109eda1a3d41e249fd2159a29a Mon Sep 17 00:00:00 2001 From: mh Date: Fri, 11 Jul 2008 14:13:03 +0000 Subject: merged with puzzle --- files/backup/mysql_backup.cron | 2 +- files/config/CentOS/setmysqlpass.sh | 2 +- files/config/my.cnf | 3 ++- files/config/my.cnf.Gentoo | 3 ++- 4 files changed, 6 insertions(+), 4 deletions(-) (limited to 'files') diff --git a/files/backup/mysql_backup.cron b/files/backup/mysql_backup.cron index fed14fb..375d910 100644 --- a/files/backup/mysql_backup.cron +++ b/files/backup/mysql_backup.cron @@ -1 +1 @@ -00 01 * * * root /usr/bin/mysqldump --all-databases --all | gzip > /var/lib/mysql/mysqldump.sql.gz && chmod 600 /var/lib/mysql/mysqldump.sql.gz +00 01 * * * root /usr/bin/mysqldump --all-databases --all | gzip > /var/lib/mysql/mysqldump.sql.gz && chmod 600 /var/lib/mysql/data/mysqldump.sql.gz diff --git a/files/config/CentOS/setmysqlpass.sh b/files/config/CentOS/setmysqlpass.sh index f4fbe12..6d17fd9 100644 --- a/files/config/CentOS/setmysqlpass.sh +++ b/files/config/CentOS/setmysqlpass.sh @@ -4,7 +4,7 @@ test $# -gt 0 || exit 1 /sbin/service mysqld stop -/usr/libexec/mysqld --skip-grant-tables --user=root & +/usr/libexec/mysqld --skip-grant-tables --user=root --datadir=/var/lib/mysql --log-bin=/var/lib/ & sleep 5 echo "USE mysql; UPDATE user SET Password=PASSWORD('$1') WHERE User='root' AND Host='localhost';" | mysql -u root killall mysqld diff --git a/files/config/my.cnf b/files/config/my.cnf index 6d3efc6..b3c1f0b 100644 --- a/files/config/my.cnf +++ b/files/config/my.cnf @@ -1,5 +1,6 @@ [mysqld] -datadir=/var/lib/mysql +datadir=/var/lib/mysql/data +log-bin=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). diff --git a/files/config/my.cnf.Gentoo b/files/config/my.cnf.Gentoo index b51ec21..de2e2b7 100644 --- a/files/config/my.cnf.Gentoo +++ b/files/config/my.cnf.Gentoo @@ -51,7 +51,8 @@ socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr -datadir = /var/lib/mysql +datadir = /var/lib/mysql/data +log-bin = /var/lib/mysql skip-locking key_buffer = 16M max_allowed_packet = 1M -- cgit v1.2.3