Noobie looking for help

[Ravieh]

I'll wait till he finishes I think.

[teddybairs1]

I was fooling around with the windows binaries for mangos Rel20 I found in the downloads section of this website (much more convenient btw than having to compile the thing from source for linux) and was using them with wine. I found they can access mysql just fine from the wine explorer. How do I reset the mysql database and start fresh from there?

[Foereaper]

Database has now been fixed. Measures have been taken to make sure the DB versioning to be more consistent in the future as well. Step by step guide:

Clone Database Rel21 branch:

git clone https://github.com/mangoszero/database -b develop21 --recursive

Run the base DB found at:

database/World/Setup/mangosdLoadDB.sql

Run update 20007_19 and 20007_20 found at:

database/World/Updates/Rel20

Run the required updates found at:

database/World/Updates/Rel21

In your case, 21000_01 to 21000_13

[Ravieh]

Gonna give that a try right now! I'll report back

[Foereaper]

I was fooling around with the windows binaries for mangos Rel20 I found in the downloads section of this website (much more convenient btw than having to compile the thing from source for linux) and was using them with wine. I found they can access mysql just fine from the wine explorer. How do I reset the mysql database and start fresh from there?

I have passed the note along for someone a little more Linux savvy to guide you through all of that, cause I haven't got a clue!

[Faded]

I was fooling around with the windows binaries for mangos Rel20 I found in the downloads section of this website (much more convenient btw than having to compile the thing from source for linux) and was using them with wine. I found they can access mysql just fine from the wine explorer. How do I reset the mysql database and start fresh from there?

If you just want to wipe the database then you can delete it and recreate it if you're logged in to mysql (from cmd: mysql -u root -p)

Then when your prompt is

mysql>

Just type in:

drop database dbname;

And then:

create database dbname;

[teddybairs1]

That's all right, I'm trying out the new database you gave. We'll see how it goes.

[teddybairs1]

Okay, so, here's my output from the terminal for the new DB:

allen@allen-3541:~/database/World/Updates$ cd Rel21

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_01_Release21_initial.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * required_21000_01_Release21_initial

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_02_update_wp_commands.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_02

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos <21000_03_Start_Up_Error_fixes.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_03

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_04_Fix_CreatureAI_Chestloot_Equip_Errors.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_04

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_05_Script_refactoring.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * required_21000_05_Script_refactoring

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_06_New_ore_nodes.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_06

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_07_Corrections_to_RegenerateStats.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_07

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_08_warden_checks.sql

Enter password:

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_09_Full_script_binding_Table.sql

Enter password:

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_10_warden_multiversion.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_10

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_11_STV_Sleeping_Creatures.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_11

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_12_aq_wareffort_game_event_gameobject.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_12

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_13_backports.sql

Enter password:

Status DB is on Version

* UPDATE FAILED * required_21000_11_STV_Sleeping_Creatures

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_14_Fix_Quest_end_scripts.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * MaNGOSZero Database Rev 21000_14

allen@allen-3541:~/database/World/Updates/Rel21$

As you can see, I ran update 21000_11 and it said it accepted it, so what happened with 21000_13?

[Ravieh]

Just a quick note: I have it running again.

[teddybairs1]

This is the output I'm getting from trying to run 21000_11 again:

allen@allen-3541:~/database/World/Updates/Rel21$ ls

21000_01_Release21_initial.sql

21000_02_update_wp_commands.sql

21000_03_Start_Up_Error_fixes.sql

21000_04_Fix_CreatureAI_Chestloot_Equip_Errors.sql

21000_05_Script_refactoring.sql

21000_06_New_ore_nodes.sql

21000_07_Corrections_to_RegenerateStats.sql

21000_08_warden_checks.sql

21000_09_Full_script_binding_Table.sql

21000_10_warden_multiversion.sql

21000_11_STV_Sleeping_Creatures.sql

21000_12_aq_wareffort_game_event_gameobject.sql

21000_13_backports.sql

21000_14_Fix_Quest_end_scripts.sql

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_11_STV_Sleeping_Creatures.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_10_warden_multiversion required_21000_14_Fix_quest_end_scripts

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_09_Full_script_binding_Table.sql

Enter password:

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_10_warden_multiversion.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_08_warden_checks required_21000_14_Fix_quest_end_scripts

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_08_warden_checks.sql

Enter password:

ERROR 1054 (42S22) at line 1: Unknown column 'required_21000_05_Script_refactoring' in 'db_version'

allen@allen-3541:~/database/World/Updates/Rel21$

[Foereaper]

Yep, seems there is another issue with 21000_13.. Darn it. Looking into it, will keep you posted. Sorry for the inconvenience, unfortunately this is the reality with the dev build sometimes.

[teddybairs1]

@Faded, Appreciate it. Might have to do this with the mangos DB. Thanks.

[teddybairs1]

@foereaper, at least we're going through and finding the bugs for you!

[Foereaper]

Good, that's the point of the dev versions

[Faded]

Just a note if on Linux, instead of doing one update at a time you can just combine them all using: cat *.sql >> all.sql

Then you would only need to import the all.sql

[Ravieh]

Small thingy

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_01_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150412_warden_db_log

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_02_auth_realmlist.sql

Status DB is on Version

* UPDATE FAILED * required_20150412_warden_db_log

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150420_warden_db_log

second one fails, no biggie as far as I can tell, it works anyway, just thought I'd mention it.

[teddybairs1]

Any news on the World Updates yet?

[Ravieh]

Still don't have it running?

Mine is working again.

[Foereaper]

Antz and I are still working on getting things up and running database wise, refactoring the database revisioning system etc Which database revision do you need? I could pack up a database for you in the mean time.

[teddybairs1]

It failed for me at 21000_13 for Rel21.

[Foereaper]

Yeah, but which version do you need? I'll patch a DB for you and dump it

[teddybairs1]

@foereaper, the database I've got the one you said to clone and use back on page three of this thread.

[teddybairs1]

So... Did I give the wrong answer? Other than what I said previously, I'm really not sure what you're asking for. I downloaded the version of mangos that you said to clone on page three of this thread. This was the one that I got stuck on in 21000_13. As far as I know, it's release 21. I'm not sure how else to identify which version it is? It's for Linux, if that's what you mean.

[Foereaper]

Hey, sorry, I was busy working on a revised database system, so I didn't have the chance to get a database set up for you What I was wondering was what version your core is expecting when you start it up. It should show you which version of the database you have, and what version your core is expecting.

Here you go, DL link to a world DB fully updated to 21000_13_Backports

https://mega.co.nz/#!A19U2DgQ!n4TWvi1h7JyuLaZ5trKQ4g0N8XGprcSUgfDs4NT6csk

[teddybairs1]

That's okay. I figured it was something like that.

Here's my output:

[A] You have: --> `21000_14_Fix_quest_end_scripts.sql`

You need: --> `21000_13_Backports.sql`

Thanks!