su - mysql -c “mysqld_safe –skip-name-resolve –open-files-limit=4096&”

cd /usr/local/mysql/bin/
mysqldump -u用户名 -p密码 –databases 库名 >/backdata/ddd07-11-15.sql
mysqldump –databases zt >/data/ok1.sql
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt</backdata/kb.sql
mysqldump -uroot -pueoadir –databases zt >/backdata/back1210.sql
su - mysql -c “mysqld_safe –skip-name-resolve –open-files-limit=4096&”
cd /usr/local/mysql/bin/
mysql -uroot -pueoadir zt4</backdata/.sql
mysql -uroot -pueoadir zt</data/ok.sql
UE处理下负区导入表
mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql uny00</data/uny00.sql

mysql FLServer</data/FLServer.sql
mysql GMTool</data/GMTool.sql
mysql LoginServer</data/LoginServer.sql
mysql roleChangeServer</data/roleChangeServer.sql
mysql roleregServer</data/roleregServer.sql
mysql uny00</data/uny00.sql

mysql FLServer</data/FLServer.sql
mysql zt</data/zt501.sql
mysql -uroot -pueoadir zt</backdata/kb.sql
查询
select * from zt4.CHARBASE where name in (select name from zt.zHARBASE)
select * from CHARBASE limit 100
select UNIONID from CHARBASE limit 100
更新
update zt4.CHARBASE name=CONCAT('区',rtrim(name)) where name in (select name from zt.CHARBASE) ‘处理重名
update CHARBASE name=CONCAT(rtrim(name),'1q')
update CHARBASE CHARID=CHARID+10
插入
insert o zt.CHARBASE SELECT * FROM zt4.CHARBASE
insert o game.user(name,pass) select name,pass from game2.user2
导入
mysql -uroot -pueoadir zt</backdata/zt2q.sql
mysql -uroot -pueoadir zt</backdata/1q.sql
删除
delete from CHARBASE WHERE ROUND=0 AND LEVEL < 80 and `LASTACTIVEDATE`< ‘2007-11-19 00:00:00′
delete from CHARBASE WHERE ROUND=0 AND _disibledevent=zt4.CARTOONPET.MASTERID
21.合并CHARBASE数据库
insert o zt.CHARBASE SELECT * FROM zt4.CHARBASE
22.合并SCHOOLMEMBER数据库
insert o zt.SCHOOLMEMBER SELECT * FROM zt4.SCHOOLMEMBER
23.合并SEPT数据库
insert o zt.SEPT SELECT * FROM zt4.SEPT
24.合并UNIONMEMBER数据库
insert o zt.UNIONMEMBER SELECT * FROM zt4.UNIONMEMBER
25.合并UNION
insert o zt.UNION SELECT * FROM zt4.UNION
26.合并CARTOONPET
insert o zt.CARTOONPET SELECT * FROM zt4.CARTOONPET
26.合并BALANCE
insert o zt.BALANCE SELECT * FROM zt4.BALANCE