Jump to content

Updating Database


Recommended Posts

Posted

I'm having problems updating the 10131_01_mangos_spell_bonus_data.sql to 10237_01_mangos_spell_bonus_data.sql using this command

mysql -u root -p Silver1726 <10237_01_mangos_spell_bonus_data.sql

Thank You

Error Message below

World Database: 127.0.0.1;3306;root;Silver1726;mangos

Connected to MySQL database at 127.0.0.1

MySQL client library: 5.1.41

MySQL server ver: 5.1.41-3ubuntu12.3

AUTOCOMMIT SUCCESSFULLY SET TO 1

Successfully turned on MYSQL_OPT_RECONNECT.

SQL: SELECT required_10237_01_mangos_spell_bonus_data FROM db_version LIMIT 1

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

[0 ms] SQL: SELECT * FROM db_version LIMIT 1

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

[A] You have: --> `10131_01_mangos_spell_bonus_data.sql`

You need: --> `10237_01_mangos_spell_bonus_data.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.

[0 ms] SQL: SET NAMES `utf8`

[0 ms] SQL: SET CHARACTER SET `utf8`

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use