Quote:
Originally Posted by DiobloSlayeR
It contain acc and chars in same, meaning the accounts and user in my, there is no account table, only my, so what shoulda do?
|
if your talking about ingame accounts they are in your my database which this table is slightly different to your existing ones
-for---the---ones---that---can---connect---to---their---db--via--navicat-
first open the connections to both your english and your chinese database rename the chinese database from my -> chinese now import it into your english database if you dont know how just goto your folders and copy and paste into your english database data folder
now run this script replacing the word [table] with the tables you want to edit
this script will delete any of the old information within your chinese database and only leave new information that your current database doesnt have
delete from chinese.[table] using my.[table] inner join chinese.[table]
where
chinese.[table].id = my.[table].id;
then when you view your chinese tables you will only see the new stuff your current database doesnt have
example:
delete from chinese.cq_action using my.cq_action inner join chinese.cq_action
where
chinese.cq_action.id = my.cq_action.id;
------------------------------------------------------
--Those that cant connect at all----------------------
------------------------------------------------------
just rename the tables you want to something like this
example: cq_action -> cq_action1 or chineseaction
then run this script simialar to the above one
delete from [chinesetable] using [englishtable] inner join [chinesetable]
where
[chinesetable].id = [englishtable].id;
example
delete from cq_action1 using cq_action inner join cq_action1
where
cq_action1.id = cq_action.id;
