Chrispeee new Db [realese]

[Chrispee]

so this db doesnt come with tables for the players since its not a repack but u can backup
your old tables and execute them in the new db .This if how to do for ACCOUNTS:
Backing Up WITH Navicat.
-Open Navicat
-Go under the antrix database
-Select ALL the following with ctrl + click:
1. Accounts
2. Characters
3. Charters
4. Corpses
5. Guild_Ranks
6. Guilds
7. Playeritems
8. Playerpets
9. Playerpetspells
10. Playersummonspells
11. Questlog
-Make sure you have ALL 11. Nothing more and nothing less.
-RIGHT click any of the 11(make sure they are all still selected),then click "Dump SQL File"
-Choose any destination and name, and save it
-Close Navicat
-Install new version of repack
-Reopen Navicat and database antrix
-Delete ALL 11 of the same exact ones you backuped
-Right click the database antrix and click "Execute Batch File.."
-Go to the sql file you saved with your accounts and open it
-It should execute sucessfully if you did it correctly
Backing Up WITHOUT Navicat
-Go to the Repack folder
-Go under mysql, then data, then antrix
-Under this folder cut or copy all the following somewhere else that you wont forget, maybe a new folder. All of the files will have 3 under the same name. Make sure you get ALL 3! Of each name.
Example: To copy the accounts. Copy all the 3 files that have accounts name in it which are accounts.frm, accounts.MYD, and accounts.MYI
1. Accounts
2. Characters
3. Charters
4. Corpses
5. Guild_Ranks
6. Guilds
7. Playeritems
8. Playerpets
9. Playerpetspells
10. Playersummonspells
11. Questlog
-Install new version
-Overite all the new files with your backuped ones.(credits for backup accounts to shadowreaper from ac-web)

[Puff]

Ty Chrispee, btw does yoru db include portals? becuase mine got messed up along with other items such as Swift Netherdrake, and soem legendary weapons.

Hmm, i get Failed - Unsuccessfully, not sure what i've doen wrong :s im executign to batch file in my db.
any tips?

EDIT**

this is the error

[Err] 1050 - Table 'accounts' already exists
[Err] -- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

Also i get teh same error when i try to back up my file, so my mates accoutns have been deleted again :S

I think iv backed up my files, btu i still cant apply your db patch :S

Thanks. or shall i click continue on errors? i just dont want to do a whole execute and it not being worth while.

[Chrispee]

u should backup up those tables i said from your old db then execute the new db then delete the 11 tables in the db then execute the old accounts it s a noob guide mate

[Puff]

I did that though, It makes no sense.

[Chrispee]

I recommend that all of u use ac-web repack

[Puff]

Im using JulianX's re-pack.

[Leeuber]

can anyone help me when i try to execute the file it finishes Unsuccessfully
Please help, tll me if im missing something or doing something wrong

[Err] 1050 - Table 'accounts' already exists
[Err] -- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

[nicky7953]

Thanks this helped.+rep

[Atomixx90]

Never mind, noob mistake, sorry, disregard this.

[00162]

yea i had a question i love the db. i was just wondering if there was anyway i can add a teleport to the teleport guy if there is please let me know. because when i make portals and you right click them i get word of recall (OLD) instead of it teleporting them where i set it

[daigold]

Guys does who are not using AC-Web repack , it is not needed , so dont worry , this can work with any repack , now the way you do it , its what causing the errors!

[slipknotfan]

after i did this ther was NO database.. Tables wher gone. =\

[Mxl5]

Nice DB, I tried 2 different repacks trying to get this to work, but the Julian X's repack worked with no problem with DB.

[Chrispee]

Yeah Then Julian X Repack Works Fine Too With This Guys Eanjoy

[ismails]

doesnt work with ac-web repack 5.8.2
i dont have any creature spawns on your databse so i better fix bugs myself