root@Debian:~# cat dumphelp.sh DATABASES_TO_EXCLUDE="test"EXCLUSION_LIST="'information_schema','mysql'"for DB in `echo "${DATABASES_TO_EXCLUDE}"`do EXCLUSION_LIST="${EXCLUSION_LIST},
导出mysqldump --single-transaction --skip-opt --create-option -F --master-data=2 -q -B -uroot game_release > game_rel0726.sql数据库game_release,用户名密码：game/!123456'db上设置grant replication slave,repl
[client]port=3306socket=/data1/mysqldata/mysql.sock[mysqld]max_connections=300tmpdir=/data1/mysqldata/tmplower_case_table_names=1bind-address=10.20.164.36datadir=/data1/mysqldata/datacharacter-set-ser
#/bin/bashPWD=`pwd` >>mysql_install.log#A.建立mysql用户、用户组、home目录groupadd mysql >>mysql_install.loguseradd -g mysql -d /home/mysql -s /bin/bash mysql -m >>mysql_install.log#b.安装mysqlmkd
[client]port = 3306socket = /data1/mysql/3306/mysql.sockdefault-character-set=latin1[mysqld]port = 3306socket = /data1/mysql/3306/mysql.sock#basedir =datadir = /data1/mysql/3306/datapid-file = /data
percona-toolkit使用教程之复制类工具http://blog.chinaunix.net/uid-20639775-id-3229211.html官网：http://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html#downloading利用pt-table-checksum做主从一致性校验http://blo
前两天做一个db-dr应用切换，db是跑在windows server 2008，dr跑在centos 6.4 64bit上面，为了方便管理数据库，需要把dr切换成为db，在切换前做了db，dr数据库表记录对比，发现部分表记录数据不一致。经过查询发现linux下的mysql对大小写敏感，win下不区分大小写，应
1.导出C:\Users\Administrator>mysqldump --opt -u root -p game_release > c:\game_release_table.sql导入create databases game_release[mysql bin path]>mysql -uroot -p game_release < game_release_ta
A.建立mysql用户、用户组、home目录groupadd mysqluseradd -G mysql -m /home/mysql -s /bin/bash mysqlb.安装mysqltar -zxvf mysql-5.5.24-linux2.6-x86_64.tar.gz mkdir -p /usr/local/mysqlmv ./mysql-5.5.24-linux2.6-x
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
