MySQL version of the PRC precacher data: part 2

Updated 5th August 2007

Now that the precacher generates the correct mySQL syntax, it’s a lot easier to create. It now only takes a few minutes, but here’s the one for NWN1.68 + PRC3.1d anyway:

outprc31e_mysql.rar

Importing it into mySQL

For Windows, assumes mySQL is in the PATH:

  1. open a command prompt
  2. go to the directory you unRARed the file
  3. type: mysql -u user -p databasename < out.sql > out.log (er…replace the user and databasename with whatever it should be)
  4. enter the password when prompted
  5. go do something else for 5 minutes (the sql instructions are 50MB uncompressed)

For Linux (with thanks to Tom), the command line is:
cat out.sql| mysql -u user -p databasename

There are several arguements that mysql takes, eg -u username and –user=username are equivalent, see the MySQL manual.

The log file will be empty, but it stops mySQL echoing a confirmation after every line of the sql file (it has a lot of lines) and it stops if it encounters an error.

(and the sqlite one for the super lazy: outprc31e_sqlite.rar)