Execute SQL takes over 10 hours

[Madara Uchiha]

i wanted to execute the database tables into the world database but some of them take more than 10 hours to execute,is this normal? is there a way to get them faster to work?

[Dynashock]

Use SQLyog to execute it instead. Both HeidiSQL and Navicat (out of the box) are really bad when it comes to executing huge queries.

[Kirsebaer]

Use SQLyog to execute it instead. Both HeidiSQL and Navicat (out of the box) are really bad when it comes to executing huge queries.

Navicat works fine

[Ground Zero]

Unless your computer is really really really really slow then no this isn't normal, takes about 10 seconds to execute a world query for me.

[stoneharry]

Using a standard Navicat and SQLyog database I tested how long it takes to execute a traditional database backup:

Navicat - 3minutes 21 seconds.
SQLyog - 17 seconds.

This is just the way the programs were designed, you can configure it so that they are equally good but it is not something the traditional user can do. Navicat presents everything in a nice friendly GUI that allows you to easily browse and edit data and manage users with ease. Basically managing. SQLyog uses a much more advanced interface which isn't as user friendly but allows you to work with the database better.

So Dynashock basically was right.

The issue in this case though could of been that your max_allowed_packets were not high enough which would have stopped the query being executed after X amount of queries. Navicat may simple have ignored this error and is waiting for it to re-establish a connection (dunno how navicat works in this case) but SQLyog would of returned a error similra to "SQL server has gone away". In this case you can simple google on how to change the maximum allowed packets.

[Harambeqt]

Unless your computer is really really really really slow then no this isn't normal, takes about 10 seconds to execute a world query for me.

Its not the PC in this case.

It took me 10 + hours to execute TrinityDB with navicat.
less than 1 min with SQLYOG

I can't execute Mangos based DB's with navicat, i can but it takes 5+ hours

[myran2]

Am I the only one that uses the command prompt for things like this?
If you've installed MySQL on your own(You do this when you've compiled your own core), then you can use this:

mysql -u USERNAME -pPASSWORD -D DATABASE < SQLQUERYPATH

USERNAME= your MySQL user (root)
PASSWORD= your MySQL password (admin, ascent etc)
DATABASE= your MySQL database that you want to execute the query to.
SQLQUERYPATH= the full path to your sql file(C:\users\myran2\desktop\query.sql)

[stoneharry]

Aye you are, the majority of users here would self-implode trying to do that, bearing in mind a lot of people can not even set up a repack. It's just easier to use something given in a nice GUI. Also quite a few repacks come with a SQL server included (based of xampp) and won't have this, and users would get confused not knowing what there using.

[myran2]

Yeah, I guess to a new person it would be much simpler to just run the query through a nice GUI :P