[Help] adding data from old to new db

05/09/2012 07:33 Jinix#1
Somehow my old database was messed up past the point of saving. I made a new one - working, and need to move the old accounts/characters/items/eudemon to the new one.

To do this i go to mysql/data/my - i know what forms hold the data i need, but there are 3 file types, .frm, .MYD, .MYI. What file types to i copy to move them to the other database.

Also there is eudemon files in the mysql/data/test folder, so i need to copy that one too?

Any help with this is much appreciated. Thanks!
05/09/2012 12:00 XxFearReaperXx#2
sq dumps if you can use navicat
Right click table.
Dump SQL....
Save File.
Run in new Database.
cq_item
cq_account
cq_user
cq_eudemon
etc.....
05/15/2012 07:57 koreng#3
Quote:
Originally Posted by XxFearReaperXx View Post
sq dumps if you can use navicat
Right click table.
Dump SQL....
Save File.
Run in new Database.
cq_item
cq_account
cq_user
cq_eudemon
etc.....
this is adding or replace?
05/15/2012 11:16 XxFearReaperXx#4
Adding. Do dump sqls and Only Insert. Delete the
Delete from cq_XXXX where XXXX and XXXX and you should be fine to add peoples stuff