Abyss\Zeb DB

[daryl]

loads of errors sourcing the sql file like ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist

with most tables
whats a good editor to open the sql file i only got notepad and wordpad here haha

[Foins]

notepad or word pad

[boogerific]

If you want a small, effective editor, try conTEXT. It's FREE (for now), pretty cool and supports all sorts of code. I'm not a programmer but I do use it for editing html. I also replaced Notepad with it.

http://www.context.cx/

[daryl]

thanks man

[Angelox]

Originally Posted by boogerific

If you want a small, effective editor, try conTEXT. It's FREE (for now), pretty cool and supports all sorts of code. I'm not a programmer but I do use it for editing html. I also replaced Notepad with it.
http://www.context.cx/

Very nice little editor for windows - glad you posted the link, thanks!

[boogerific]

Oh yeah, I forgot to mention that it's Windows program. Thanks for pointing that out, Angelox.

[John Adams]

Originally Posted by daryl

loads of errors sourcing the sql file like ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist
ERROR 1146: Table 'newdb.grid_entries' doesn't exist

with most tables
whats a good editor to open the sql file i only got notepad and wordpad here haha

If you're sourcing in the original db from Amra (linked above), you should have no problems with missing tables - since it creates them for you.

A great tool to use is SQLYog. Just use the Restore from SQL Dump option and you're in business. Follow Amra's original post to tweak what is needed to allow new players, should you choose to run it publicly.

[GeorgeS]

Context editor is an excellent tool, and also you will need WinHex, another neat tool for browsing binary data. Now if only Context dealt with binary data...

GeorgeS

[Amra]

Originally Posted by John Adams

Follow Amra's original post to tweak what is needed to allow new players, should you choose to run it publicly.

If you do decide to run it publicly you should know there isn't a good balance on the server. I would wipe the character/account table completely,review Loot drops, nerf the buff bot and revamp some higher level items. It's a huge project that I didn't want to invest in. But the content is amazing. With a lot of work it could be an awesome db. Just my opinion.

But a lot of people liked it the way it was. And that's cool with me

I have the original DB without my modifications if you would like that. I will see if I can get a host somewhere.

oh and don't forget to change access levels (as john pointed out) on the accounts and zones if you choose not to wipe the player-base. It will prevent new accounts from being able to zone into the server. Other than that good luck.