Player Resource Consortium

Neverwinter Nights => Help => Topic started by: KenquinnTheInsaneOne on August 17, 2009, 07:01:05 PM

Title: PRC .SQL File - Updated
Post by: KenquinnTheInsaneOne on August 17, 2009, 07:01:05 PM

Hello Everyone,

Right now I am loading .SQL file generated by the precatcher in to a mySQL database.

I have two questions is the file being 66MB normal and how long does the loading precess normally take?

Its been going on for about 30 minutes so far and is still adding all the baseitem entries. Which is about the first 5% of the text file. At this rate its going to take 20+ hours to be done.

Edit: I'm using MySQL 5.1

Title: PRC .SQL File - Updated
Post by: rafhot on August 17, 2009, 07:09:48 PM

the pre cacher is really slow the best way is get the prc server pack and make the out.sql by him and use the insert  by command line on mysql instead use any front ends

in the prc server pack manual have the documentation with the  how to to use te mysql in command line to add the out sql to the database

Title: PRC .SQL File - Updated
Post by: DM Heatstroke on August 17, 2009, 07:52:54 PM

It still takes a really long time to load it in, at least on my older system.  A friend just told me yesterday that it's possible to "connect" multiple MySQL installations so that you can use more than one PC to work on a single thing, but I haven't looked into it yet.

Title: PRC .SQL File - Updated
Post by: dsabrae on August 17, 2009, 08:29:18 PM

takes me about 4-7 hours I havnt watched it in awhile I tend to do it then go to bed.

Title: PRC .SQL File - Updated
Post by: KenquinnTheInsaneOne on August 17, 2009, 08:37:35 PM

Edit:Last line of the out.sql file is the following and I think its where it is getting stuck as its the second point where prc_cached2da_item_to_ireq appears in the file.

Edit: I think I found the reason its getting the cant find table error its because there is no CREATE TABLE "prc_cached2da_item_to_ireq" line.

Code: [Select]

CREATE UNIQUE INDEX `refrindex`       ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`);

Quote from: rafhot

the pre cacher is really slow the best way is get the prc server pack and make the out.sql by him and use the insert  by command line on mysql instead use any front ends

in the prc server pack manual have the documentation with the  how to to use te mysql in command line to add the out sql to the database

I just made the out.sql but I'm using a SQL frong end to load it to the DB will try using the command line instead.

Edit: Took me a bit to figure out how to do it from the mysql.exe command line as I used the zip install.

Code: [Select]

/. out.sql
I used that ran for 45 seconds and got a table does not exist error. Which makes no sense as I am trying to make new tables.

Code: [Select]

prc_catced2da_item_to_ireq does not exist

[Edit: I have a E6600 core 2 duo @2.4 GHz

I am going to do a fresh install of 3.3f

Fresh install of 3.3f did not fix the error looking at the out.sql file[/i]

Title: PRC .SQL File - Updated
Post by: KenquinnTheInsaneOne on August 18, 2009, 02:48:37 PM

I removed the two mentions of prc_cached2da_item_to_ireq from the out.sql file to get rid of the error and the PRC test module seems to be working perfectly now.

Now the question I have is the prc_cached2da_item_to_ireq needed and if it is can someone tell me what variables I need to set up in the prc_cached2da_item_to_ireq table?

Title: PRC .SQL File - Updated
Post by: Stratovarius on August 18, 2009, 04:57:18 PM

That file was taken out a while ago.

Title: PRC .SQL File - Updated
Post by: KenquinnTheInsaneOne on August 18, 2009, 06:42:57 PM

Quote from: Stratovarius

That file was taken out a while ago.

I wonder why it was added to the out.SQL file then

Title: PRC .SQL File - Updated
Post by: Stratovarius on August 18, 2009, 10:50:04 PM

Because the out file was written before that was removed.