Executing queries is taking days.

[CellPunk]

I am trying to get a new server set up after I have been using repacks for quite a while, as when I tried to execute the actual world database stuff it takes a large amount of time to complete. I have let it run for nearly a day now, and it still is at 5MB/216MB. Is this normal? Do I have to just leave it running even longer? I am still a newbie with the actual coding of servers and whatnot, but I want to learn. Thanks in advance.

[Trygve]

why use your time on a game that is already developed?
Use your time on creating a game. more $ for you

[CellPunk]

I have a lot more fun with World of Warcraft, and me and some friends are just looking to mess around.

[Valmere]

I am trying to get a new server set up after I have been using repacks for quite a while, as when I tried to execute the actual world database stuff it takes a large amount of time to complete. I have let it run for nearly a day now, and it still is at 5MB/216MB. Is this normal? Do I have to just leave it running even longer? I am still a newbie with the actual coding of servers and whatnot, but I want to learn. Thanks in advance.

What program are you using? Navicat / Hiedi / ??

why use your time on a game that is already developed?
Use your time on creating a game. more $ for you

gtfo?

[CellPunk]

HeidiSQL. I tried Navicat but it came up with a memory error.

[riizu]

What kind of PC are you running? It could be that you have an extremely old PC that can't handle the load. For example, on my recently built machine, I execute a world DB in less than a minute sometimes. So this could very well be a hardware issue.

As for the memory issue, you do have the obligatory .NET Framework 3.5 (or is it 4?) installed correct?

If your running Vista/Win 7, it never hurts to try enabling Run In Administrator mode or an older compatibility mode.

Also, i've never personally ran HeidiSQL. I have always stuck MySQL or Navicat. Possibly try switching the program if you can.

[2dgreengiant]

Try to increase the max sql file size you can execute in the .ini files and use SQLyog, its built for things like this

[CellPunk]

The computer is not the problem, but I will try increasing the max file size and I will go grab SQLyog. Thanks to all the responses.

[riizu]

Try to increase the max sql file size you can execute in the .ini files and use SQLyog, its built for things like this

Totally meant SQLyog. :P

[CellPunk]

Picked up SQLyog and it's executing like a dream. Thanks Greengiant.