Update SQLyog

[Auntie Mangos]

Bump

um im using this guide http://getmangos.eu/community/viewtopic.php?id=7318

Im up to step 10. Updating databases

anyone can explain if anyone has made an server??

[anthonyo]

ok i need to update to

required_10423_01_mangos_spell_chain required_10427_01_mangos_spell_proc_event bit

but thats 2000 or more updates away... is there a quicker way to do it all at once...:angry:

[NickoNiklas]

You start by reading the guides on how to update,

and there are plenty of threads that explains that.

If you're using a content database,

check that content database forum on how to update too.

And noone here can read your mind.

Without any other information, noone here can help you.

And by the way,

there are a total of 1517 sql update files for mangos,

and unless you're updating from rev. 1150,

to the latest release of mangos,

you will never use all of them.

[anthonyo]

2010-09-17 01:37:28 MaNGOS/0.17.0-DEV (* * Revision 10489 - *) for Win32 (little-endian) [world-daemon]

2010-09-17 01:37:28 <Ctrl-C> to stop.

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2010-09-17 01:37:28 Using configuration file mangosd.conf.

2010-09-17 01:37:28 World Database: 127.0.0.1;3306;root;(password);mangos

2010-09-17 01:37:28 MySQL client library: 5.1.49

2010-09-17 01:37:28 MySQL server ver: 5.1.50-community

2010-09-17 01:37:28 ERROR:SQL: SELECT required_10457_01_mangos_spell_proc_event FROM db_version LIMIT 1

2010-09-17 01:37:28 ERROR:query ERROR: Unknown column 'required_10457_01_mangos_spell_proc_event' in 'field list'

2010-09-17 01:37:28 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2010-09-17 01:37:28 ERROR:

2010-09-17 01:37:28 ERROR: [A] You have: --> `10427_01_mangos_spell_proc_event.sql`

2010-09-17 01:37:28 ERROR:

2010-09-17 01:37:28 ERROR: You need: --> `10457_01_mangos_spell_proc_event.sql`

2010-09-17 01:37:28 ERROR:

2010-09-17 01:37:28 ERROR:You must apply all updates after [A] to to use mangos with this database.

2010-09-17 01:37:28 ERROR:These updates are included in the sql/updates folder.

2010-09-17 01:37:28 ERROR:Please read the included [README] in sql/updates for instructions on updating.

i have updated for 1h and get differnet messegers all the time

ok has anyone made a server before using mangos and used SQLyog.... how did u update it?

like i have t go through all the texts and i copy the wrong one and stuffs it up..

[Darkruler]

right mouse button on the "mangos" database -> import -> "restore from sql dump"

now import the files one by one, the structure is:

version_subversion_affecteddatabase_affectedtable.sql

import all files with the "affecteddatabase" part being "mangos" and the version HIGHER than the one you have

[anthonyo]

right mouse button on the "mangos" database -> import -> "restore from sql dump"

now import the files one by one, the structure is:

version_subversion_affecteddatabase_affectedtable.sql

import all files with the "affecteddatabase" part being "mangos" and the version HIGHER than the one you have

how do i check what im up to?

[NickoNiklas]

how do i check what im up to?

By reading the error. It explains exactly what you have to do.

[anthonyo]

By reading the error. It explains exactly what you have to do.

Once i run the one it says to run it tells me to run a different one and again and again and again.....

[xeross155]

Please carefully read the guide and the things people have said here, if you still don't get it, keep re-reading until you do. And you need to apply everything from the current one it says it has to the latest one in the sql updates folder.

[anthonyo]

Stuf it i found an awsom repack! http://forum.ragezone.com/f436/mangos-amber-releases-3-x-x-549955/

works like anything else!

[NickoNiklas]

You should remove the repack link before the mods can see it.

Repacks are not supported here,

and it's not hard to create a server,

it just takes time.

And if you would like more help with this update problem,

you should first check the guides and search the forum.

There are hundreds of threads about this problem,

and most of them has the answer how to solve it,

you just need to take some time reading about it.

Even the error message is easy to read and understand,

just pay attention to what it wants to tell you.

But remember, if you use that repack,

don't ask about problems with it in this forum.

[EARTHWALKER]

repack? lmao. Move along people, nothing to see here.