Is it supposed to take this long?

Kintar0 · #1 11-08-2004, 01:27 AM

Currently, I'm setting up my eqemu server. I followed the guide...etc it's all good but just one question.

When I'm dumping the PEQ_Classic into the mysql db, is it supposed to take 2 hours? Kuz thats how long it's been now. Still spamming the "Query OK, 1 row affected"... line. I know it's a big file but damn 2 hours? I"m on a 2.5ghz 1 gig ram too, or is this normal to take forever?

Also, might be a lil late but if I want kunark, should I just have downloaded PEQ_Kunark_Relase? or is that in addition to classic? The website seems down now so I can't download it all.

1010101 · #2 11-08-2004, 02:25 AM

Quote:

Originally Posted by Kintar0

I know it's a big file but damn 2 hours? I"m on a 2.5ghz 1 gig ram too, or is this normal to take forever?

Takes less than ten minutes on my 2.8ghz P4 w/ 512 mb of RAM. My laptop (2.3 ghz Mobile P4 w/ 256 mb RAM) probably took a little more than ten. Of course, I'm impatient so those numbers might have been shorter

.

Quote:

Originally Posted by Kintar0

Also, might be a lil late but if I want kunark, should I just have downloaded PEQ_Kunark_Relase?

You only need the Kunark release if you want "Old World" EQ plus Kunark.

Muuss · #3 11-08-2004, 02:27 AM

Launch mysql with the -s option. Drawing on your console all those rows takes more time than sourcing all the file into the DB !

govtcheeze · #4 11-08-2004, 02:35 AM

or do it from the command line:

Code:

~>mysql -f -u(username) -p (dbname) &lt; (filename.sql)

Kintar0 · #5 11-08-2004, 04:43 AM

Hmm, -s does absolutely nothing it seems kuz it still spams like mad. and I was doing it from commandline, does the same thing also.

Now it seems to jam up and stops trying to write to the DB after a few mins of spamming "Error duplicate entry"...etc. Or does the -s option mean it's working when it seems to be "stuck" or "jammed"? Any other suggestions?

Kintar0 · #6 11-08-2004, 06:55 AM

OK, the -s option did work and silenced it. I noticed because the mysql directory was getting larger in size. But it's still taking forever to finish. I'm using "source PEQ_Classic_058.sql;", it's still taking forever. Is this particular file supposed to take this long to dump? Since I've restarted it's been near 3 hours now and still going. Any suggestions?

sotonin · #7 11-08-2004, 06:59 AM

depends on your computer. it can take that long.

And you should be sourcing kunark imo,. Many many improvements over classic.

Kintar0 · #8 11-08-2004, 07:01 AM

got a 2.5ghz AMD 1 gig ram. i figure that's decent, shouldn't be taking this long hehe. I guess i'll jsut go do kunark.

sotonin · #9 11-08-2004, 07:06 AM

mine takes maybe 15 mins. i have about the same system

govtcheeze · #10 11-08-2004, 07:55 AM

Your harddrive speed also has a lot to do with it. It used to take me 4+ hours to source in my updates on my old rig, now it takes 15 minutes. VERY computer dependant...if time is a problem, start it just before bed and it will be done by the next morning...unless your computer REALLY sucks.

Kintar0 · #11 11-08-2004, 08:19 AM

perhaps it's kuz i haven't rebooted in a week. it finally finished tho heh

**Rogean** · #12 11-08-2004, 09:08 AM

Mine takes about 3-5 minutes. =)

cloud2276 · #13 11-08-2004, 09:26 AM

I usually bring up taskmanager (control+alt+delete on XP/NT systems)
select process tab, and right click on cmd.exe select priority, and set it to high(or realtime if your not doing anything but sourcing) also, do the same to mysql.exe right before you start sourcing your files. That will give those tasks more cpu time, and should help decrease the time.

wize_one · #14 11-08-2004, 09:53 AM

hehe how long does it take you to read 191 megs of data?.. bet your puter will be done long b4 you are..

phasepuma · #15 11-08-2004, 10:32 AM

mine sources pretty fast, around 5 minutes or so. =)