Getting DB in SQLyog taking to long.

[Kendratjuh]

It took more than 1 hour and my computer is a dual core.
I deleted whole DB once by accident (stupid me), has that any influence?

 

[Masaki94]

Mine always takes around 2 hours normally, its alot of packets.

 

[Quakes69]

Mine always takes around 2 hours normally, its alot of packets.

Same here. Only on the antrix.sql file tho. 2 hr wait

 

[gerard1989]

The Navicat is better to getiing new DB.

 

[gerard1989]

it's faster

 

[Kendratjuh]

Using that, but just incase people dont know what Navicat is .

 

[Masaki94]

Same here. Only on the antrix.sql file tho. 2 hr wait

Yeah, only the antrix.sql does that to me >.< :construct

 

[gerard1989]

I dont know ehy the antrix db and terranet db is so huge. The SDB is better and smaller

 

[Kendratjuh]

10000 seconds now -_-
First time only took 10 mins...

 

[Kickfoot]

my 700 mhz server just needs 7 min or something for mangos sdb.
and for antrix over an hour xD

 

[bytebull]

I don't know what mysql and apache you use ... but with SQLyog it only takes my comp about 2 minutes ... close to 3 minutes .. to import the .sql file.

Make sure you read the tutorial and in SQLyog go to DB / restore from Dump

make sure you have removed the entire previous database first....

so you have the antrix or antrix_server database made .... .but no tables ... empty database otherwise you might get errors for trying to create tables that already exist..

there's a excellent tutorial on this here but I forgot the url.

If it's taking you longer your comp might be messed..... something messing with your cpu cycles or threads .. maybe even a virus or malware...

with a dual core and 1G ram you shouldn't take that long . you might want to check your system for crap.

 

[halfox]

No the only problem is that sqlyog has an option 'Create Bulk Insert statements' when you make a dump-file of the DB.
If this option was checked when creating a dump-file of the database it wil take a LONG time to insert the statements in the new database.
When it is left unchecked the file is done in a time of minutes.

And there are a lot of databases created like that on this site.

(Navicat has no such option)

 

[ATTILA888]

I have a pentium d915 (dual core 2,8ghz) and 2gb ram ddr2 and antrix database takes about 15-20 minutes. The others takes few seconds.

 

[halfox]

I have a pentium d915 (dual core 2,8ghz) and 2gb ram ddr2 and antrix database takes about 15-20 minutes. The others takes few seconds.

Like i said. It depends on how the SQLdump-file is created.