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.
CREATE UNIQUE INDEX `refrindex` ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`);
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.
/. 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.
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]