Dynamic zone failed

[sakrod]

Try dropping the database and re-sourcing it from scratch using the installer instead of just copying over the old one.

Open up my sql -> Start/run/"c:\mysql\bin\mysql -u root"
Drop your database -> drop eq; or drop peq; depending on database name.
Exit sql
Reinstall serverpack

[shamanistik]

Originally Posted by sakrod

Try dropping the database and re-sourcing it from scratch using the installer instead of just copying over the old one.

Open up my sql -> Start/run/"c:\mysql\bin\mysql -u root"
Drop your database -> drop eq; or drop peq; depending on database name.
Exit sql
Reinstall serverpack

Drop eq; don't work, and not sure how to source a complete DB also :/

[sakrod]

Drop eq; don't work

I apologize, the command if you are using cavedude's database is "drop database eq; "

If you are using peq's, the command is "drop database peq;"


When you reinstall the server pack, it sources the database for you, so you do not manually need to do it..as stated in my previous post.

re-sourcing it from scratch using the installer

[shamanistik]

I reinstalled the server pack and it work.. but I lost my database and 2 full days of work.. : (

Since I only edited mobs and spawnpoints.. what killed my DB??
This time I only used PEQeditor to remove/add spawn point and mobs

Last time it crashed after a long quest script..

Would really like to stop losing my databases :/

[shamanistik]

Same problem :(

Fresh new titanium install, fresh DRP server install.

(EQgame freeze sometimes and crash to desktop, chain doing it, until I change account it worked.. maybe a problem from accounts???)

Well I log in to my server, create a character, kill a mob, zone, everything work.
I camp, logout, close the server with CTRL C.

Open PEQeditor, log in, remove all spawn points, then all loot tables, then all mobs (1 by 1, starting in order above) in Kurn zone

I create a named mob, add a spawn point in a safe loc I already know about

Create another mob, add spawn points (10) safe locs also
Create a second mob with same name, different ID (of course) and different look
Add this mob in the spawngroup, balance chances to pop

I log out from PEQeditor, close firefox

I launch Questeditor, select kurn zone, find my 3 mobs in kurns (actually find 1 X 5 times the same mob + 1 X 5 times the other mob + the named mob

I open the named mob, select PEQ template, modify answer to hail by 'Greetings broodling'
Click save, then quit

I launch EQemu server

Same error as above..

[LAUNCHER__STATUS] Zone dynamic_01 has gone down. Restart timer started.

?????????

Thanks for the help :(

[Dr Zauis]

If I were you Id find sqlyog program and learn to use it..I have many databases I use. I back up before I change stuff just copy paste rename.
I use sql queries only to change stuff. sqlyog is kinda buggy to change single
values by the table method.

[shamanistik]

Thanks for the advise, already found some sites with trainings and tutorials, will try to find this ; )

[shamanistik]

Thanks, just DL the free version and looked at it, it seems less and less complicated now, maybe a day I'll talk in mySQL with my hamster

Thanks again man, looks like a great tool