database Error in updates for Mangoszero Rel21

[teddybairs1]

Reinstalling Mangos after changing over my OS a couple of times. Having trouble with updating the database, specifically the Realm database. This is my feedback:

root@debian:/home/allen/database/Realm/Updates/Rel19# mysql -u root -p mangos < 20140607_Realm_Resync.sql

Enter password:

ERROR 1146 (42S02) at line 1: Table 'mangos.realmd_db_version' doesn't exist

No idea what it's talking about.

This is my output when I try to run either realmd or mangosd:

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

And this is my output when I try and rectify the situation:

root@debian:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150412_01_warden_db_log.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20150409_Playerbot_and_Warden NULL

root@debian:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150409_Playerbot_and_Warden.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20140607_Realm_Resync NULL

I'm not the greatest with mysql, and I know some of the guys on here have helped me get it running well before. Just wondering if I could get a hand.

Thanks.

[Olion]

root@debian:/home/allen/database/Realm/Updates/Rel19#

mysql -u root -p [color="#FF0000"]mangos[/color] < 20140607_Realm_Resync.sql

The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

The mysql command above tries to modify "mangos" database. The Mangos setup contains 3 databases (named by default as realmd, characters0, and mangos0). The core informs you about an issue with REALMD database, so the mentioned updates must be applied to "realmd". The following command looks correct:

mysql -u root -p realmd < 20150412_01_warden_db_log.sql

[teddybairs1]

I caught that after I posted it, went back and tried to fix it and got a different error message. I'm not on my laptop at the moment so I can't recreate the output and post it.