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?
Printable View
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?
Mine always takes around 2 hours normally, its alot of packets.
Same here. Only on the antrix.sql file tho. 2 hr waitQuote:
Originally Posted by Masaki94
The Navicat is better to getiing new DB.
it's faster
Using that, but just incase people dont know what Navicat is ;).
Yeah, only the antrix.sql does that to me >.< :constructQuote:
Originally Posted by Quakes69
I dont know ehy the antrix db and terranet db is so huge. The SDB is better and smaller :P
10000 seconds now -_-
First time only took 10 mins...
my 700 mhz server just needs 7 min or something for mangos sdb.
and for antrix over an hour xD
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.
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)
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.Quote:
Originally Posted by ATTILA888