The previous frame of the journey of the area of the SQL statement code Backup _ database Other

Su-mysql-c "mysqld_safe–skip-name-resolve–open-files-limit=4096&"



cd/usr/local/mysql/bin/
Mysqldump-u User name-p password –databases library name >/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/new.sql
Mysql-uroot-pueoadir Zt</data/ok.sql
The UE handles the lower Negative Zone import table
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 Unify00</data/unify00.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 Unify00</data/unify00.sql



MySQL Flserver</data/flserver.sql

MySQL Zt</data/zt501.sql
Mysql-uroot-pueoadir Zt</backdata/kb.sql
Inquire
SELECT * from Zt4. Charbase where name in (select name from Zt.zharbase)

SELECT * FROM Charbase limit 100
Select Unionid from charbase limit 100

Update
Update ZT4. Charbase set Name=concat (' One zone ', RTrim (name)) where name in (select name from ZT.) charbase) ' Handle duplicate names

Update charbase Set Name=concat (RTrim (name), ' 1q ')

Update Charbase Set charid=charid+10

Insert
INSERT INTO ZT. Charbase SELECT * from ZT4. Charbase
Insert into Game.user (name,pass) Select Name,pass from Game2.user2

Import
Mysql-uroot-pueoadir Zt</backdata/zt2q.sql
Mysql-uroot-pueoadir Zt</backdata/1q.sql

Delete
Delete from Charbase WHERE round=0 and Level < Lastactivedate ' < ' 2007-11-19 00:00:00′
Delete from Charbase WHERE round=0 and onlinetime<4962 and ' lastactivedate ' < ' 2007-11-19 00:00:00′



1. Remove players who are offline for more than five days and have less than 1 hours of online time!
Delete from ZT. Charbase WHERE round=0 and onlinetime<4962 and ' lastactivedate ' < ' 2007-12-10 00:00:00′

Delete from ZT. Charbase WHERE round=0 and level<80 and ' lastactivedate ' < ' 2007-11-22 00:00:00′
2. Remove GM Charid number repeat
SELECT Max (Charid) from ' Charbase '

Update ZT4. Charbase set charid=charid+10000 where Charid < LIMIT 50
Update ZT4. Charbase set charid=charid+20000 where Charid in (select Charid from ZT. Charbase)

3. Remove the duplicate names
Update ZT4. Charbase Set Name=concat (RTrim (name), ' O ') where name in (select name from ZT.) Charbase)

4. Insert Table 2 data to table 1

INSERT INTO ZT. Charbase SELECT * from ZT4. Charbase

________________________________________________
Delete from Zt4. Charbase WHERE round=0 and onlinetime<4962 and ' lastactivedate ' < ' 2007-11-22 00:00:00′
Delete from Zt4. Charbase WHERE round=0 and level<96 and ' lastactivedate ' < ' 2007-12-10 00:00:00′
SELECT Max (Charid) from ZT4. Charbase
SELECT * from Zt4. Charbase Limit 100
Update ZT4. Charbase set charid=charid+10000 where Charid in (select Charid from ZT. Charbase)
Update ZT4. Charbase Set Name=concat (RTrim (name), ' Oo ') where name in (select name from ZT.) Charbase)

INSERT INTO ZT. Charbase SELECT * from ZT4. Charbase
___________________________________________________________________________________
1. Remove players who are offline for more than five days and have less than 1 hours of online time!
Delete from ZT. Charbase WHERE round=0 and onlinetime<4962 and ' lastactivedate ' < ' 2007-11-22 00:00:00′
Delete from Zt4. Charbase WHERE round=0 and onlinetime<4962 and ' lastactivedate ' < ' 2007-11-22 00:00:00′
Delete from ZT. Charbase WHERE round=0 and level<80 and ' lastactivedate ' < ' 2007-11-22 00:00:00′
Delete from Zt4. Charbase WHERE round=0 and level<80 and ' lastactivedate ' < ' 2007-11-22 00:00:00′



2.CHARBASE table Charid processing duplicate ID plus 10000

Update ZT4. Charbase set ZT4. Charbase. Charid=zt4. Charbase. charid+10000 where ZT4. Charbase. Charid in (select Charid) from ZT. Charbase)
Cartoonpet of Cartoonid and Main library cartoonpet in the exterior of the table
Update ZT4. Cartoonpet set ZT4. Cartoonpet. Cartoonid=zt4. Cartoonpet. cartoonid+10000 where ZT4. Cartoonpet. Cartoonid in (SELECT zt4. Cartoonpet. Cartoonid from ZT. Cartoonpet)





3.SEPT table Septid processing Repeat, repeat ID plus 10000
Update ZT4. Sept,zt. Sept set ZT4. Sept. Septid= Zt4. Sept. septid+10000 where ZT4. Sept. Septid in (select Septid) from ZT. Sept)

4.UNIONMEMBER Unionid Treatment Repeat before add 10000

Update ZT4. Unionmember set ZT4. Unionmember. Unionid= Zt4. Unionmember. unionid+10000 where ZT4. Unionmember. Unionid in (select Unionid) from ZT. Unionmember)

Synchronization of Septid and Sept table in 5.UNIONMEMBER interior and exterior
Update ZT4. Unionmember,zt4. Sept set ZT4. Unionmember. Septid=zt4. Sept. Septid WHERE Zt4. Unionmember.name=zt4. Sept. MASTER
Synchronization of Unionid and Unionmember table in 6.UNION interior and exterior
Update ZT4. Union,zt4. Unionmember set ZT4. UNION. Unionid=zt4. Unionmember. Unionid WHERE Zt4. UNION. Master=zt4. Unionmember.name

Synchronization of Unionid and Unionmember table in 7.SEPT interior and exterior

Update ZT4. Sept,zt4. Unionmember set ZT4. Sept. Unionid=zt4. Unionmember. Unionid WHERE Zt4. Sept. Master=zt4. Unionmember.name

8.CHARBASE table Septid Processing is consistent with Sept
Update ZT4. Charbase,zt4. Sept set ZT4. Charbase. Septid=zt4. Sept. Septid WHERE Zt4. Charbase.name=zt4. Sept.name
9.CHARBASE Unionid processing is consistent with unionmember Unionid table
Update ZT4. Charbase,zt4. Unionmember set ZT4. Charbase. Unionid=zt4. Unionmember. Unionid WHERE Zt4. Charbase.name=zt4. Unionmember.name
10.SEPT Charid is consistent with Charid in Charbase
Update ZT4. Charbase,zt4. Sept set ZT4. Sept. Charid=zt4. Charbase. Charid WHERE Zt4. Charbase.name=zt4. Sept. MASTER
The MasterID in the Cartoonpet table and the Charid in Charbase
Update ZT4. Cartoonpet,zt4. Charbase set ZT4. Cartoonpet. Masterid=zt4. Charbase. Charid where ZT4. Charbase.name=zt4. Cartoonpet. Mastername
12.UNIONMEMBER Charid is consistent with Charid in Charbase
Update ZT4. Charbase,zt4. Unionmember set ZT4. Unionmember. Charid=zt4. Charbase. Charid WHERE Zt4. Charbase.name=zt4. Unionmember.name

13.SCHOOLMEMBER Charid is consistent with Charid in Charbase
Update ZT4. Charbase,zt4. Schoolmember set ZT4. Schoolmember. Charid=zt4. Charbase. Charid WHERE Zt4. Charbase.name=zt4. Schoolmember.name



14.CHARBASE table name and main Library charbase name duplicate processing

Update ZT4. Charbase Set Name=concat (RTrim (name), ' Oo ') where name in (select name from ZT.) Charbase)

15.SEPT table name and main Library Sept name duplicate processing

Update ZT4. Sept set ZT4. Sept.name=concat (RTrim) (ZT4. sept.name), ' Oo ', where zt4. Sept.name in (select NAME from ZT. Sept)

16.UNION table name and main Library union name duplicate processing
Update ZT4. UNION set ZT4. Union.name=concat (RTrim) (ZT4. union.name), ' Oo ', where zt4. Union.name in (select NAME from ZT. UNION)





Processing of schoolmember names of Serialid and main libraries in 17.SCHOOLMEMBER interior and exterior
Update ZT4. Schoolmember set ZT4. Schoolmember. Serialid=zt4. Schoolmember. serialid+10000 where ZT4. Schoolmember. Serialid in (select Serialid) from ZT. Schoolmember)
18.SEPT Table Master character name and charebase characters in sync
Update ZT4. Charbase,zt4. Sept set ZT4. Sept. Master=zt4. Charbase.name WHERE Zt4. Charbase. Charid=zt4. Sept. Charid

19.SCHOOLMEMBER table name and charbase character name synchronization
Update ZT4. Charbase,zt4. Schoolmember set ZT4. Schoolmember.name=zt4. Charbase.name WHERE Zt4. Charbase. Charid=zt4. Schoolmember. Charid

20.UNION Table Master character name and charebase characters in sync
Update ZT4. Charbase,zt4. UNION set ZT4. Union.name=zt4. Charbase.name WHERE Zt4. Charbase. Charid=zt4. UNION. Charid
22.CARTOONPET table Mastername and charebase in sync with the characters in the name
Update ZT4. Charbase,zt4. Cartoonpet set ZT4. Cartoonpet. Mastername=zt4. Charbase.name WHERE Zt4. Charbase. Charid=zt4. Cartoonpet. MasterID

21. Merging Charbase databases
INSERT INTO ZT. Charbase SELECT * from ZT4. Charbase
22. Merging Schoolmember databases
INSERT INTO ZT. Schoolmember SELECT * from ZT4. Schoolmember
23. Merging Sept databases
INSERT INTO ZT. Sept SELECT * from ZT4. Sept

24. Merging Unionmember databases

INSERT INTO ZT. Unionmember SELECT * from ZT4. Unionmember

25. Combine Union
INSERT INTO ZT. UNION SELECT * from ZT4. UNION

26. Combined Cartoonpet
INSERT INTO ZT. Cartoonpet SELECT * from ZT4. Cartoonpet

26. Combined Balance
INSERT INTO ZT. BALANCE SELECT * from ZT4. BALANCE