Help with LGKeiz's DB

Status
Not open for further replies.
Junior Spellweaver
Joined
Jan 12, 2007
Messages
128
Reaction score
0
Location
CA
I don't want to delete my current database that already has 100 accounts registered on it and like 100 characters on it. How to delete that database and put LGKeiz's new DB into it without deleting any of the accounts or characters? If that's not possible, then how to create a new database? If you want to reply with "You have to edit the ODBC", please tell me what I have to edit in the ODBC. Thanks.
 
Edit: Got it to work forgot to change the USE [GunzDB] to my new DB name.

Tried that but I still get these related errors:

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Items' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Locator' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Accounts' in the database.
etc etc etc

It's still connecting to the GunzDB database instead of my new database.
 
Upvote 0
There is no need to make a new database..
Say you have your characters and accounts,

What you do is Delete every other table EXCEPT accounts & characters
Then open LG's DB and remove the "CREATE TABLE ACCOUNTS blah blah blah"
"CREATE TABLE CHARACTERS BLAH BLAH BLAH"

-.- then run the query.
 
Upvote 0
Status
Not open for further replies.
Back