First time user -- setting up mysql and database

[Toro]

Hello everyone,
first off I'd like to say that NWN1 lives !! and its mostly due to people like yourselves who have contributed sooo much to this game.

Ok as stated above, I am a first time user and fairly competent at following directions but I am stuck at some pretty early stage things and its disheartning but I shall prevail.

I have mySQL 5.0 installed and can access it from mysql command line client, i have a password on it also and have no trouble getting to the mysql>
I also have the administrator tool installed.

Ok my first question (pardon if its very noob) Everything I seem to want to do requires a username , no where when i set up the server did it ask me to setup a username. for instance, when i run the admin tool, it asks for username.

i also have the PRC server pack installed because this is what I'm trying to get running it has instructions but I get to this part and I am stuck

"Using mySQL
This assumes mySQL is in the PATH for Windows. The precacher creates a file called out.sql, which needs moving to the server where the mySQL database is going to be created.

open a command prompt
go to the directory you put out.sql in
type: mysql -u user -p databasename < out.sql > out.log (replace the user and databasename with whatever it should be)
enter the password when prompted


"
These instruction are assuming that i already have a database going i think. However I do not. The prc server pack did not contain the aps module that I've read so much about that creates the databases for you.
Can i use the mod that comes from the vault to create the database?
i have a file run from the precacher mysql bat named out.sql. This can be added with the admin tool right?

Thxs for any assistance,
I'm sure I'll have a ton of more questions
I know this questions regard the prc server pack but i felt that you guys might be able to help me more because its specific to the mysql database,
but if not, i apologize.

[Papillon]

[Toro]

the password is no problem, it did ask me on installation. It was just the username which had me scratching my head

so this statement
type: mysql -u user -p databasename < out.sql > out.log

would look like this (assuming i name my DB "nwn")
mysql -u root -p nwn <out.sql > out.log

ps. i installed the gui tools and root as username worked !!
The query browser asked me for a default schema?? although it said i can ignore this, what is it asking for??

ok figured out that the default schema its asking for is basically which database you want to start out in..

Another question: i looked at the mysql admin tool also, is there a way to import that out.sql thru the GUI , (i suck at typing commands, they never seem to work) so whats the easiest way to to import that out.sql into ( i managed to create a blank database called nwn) my nwn database??

ok tried to create the tables via the aps module but i couldnt get it to create the tables
this is my nwnx_odbc.text

NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org

o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using MySQL connection.
o Hooking SCO....hooked at 5d3560
o Hooking RCO....hooked at 5d3440
o Connect successful.
o Got request: DROP TABLE pwdata
! SQL Error: Unknown table 'pwdata'
o Got request: CREATE TABLE pwdata (player text(64),tag text(64),name text(64),val memo,expire text(4),last date)
! SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'memo,expire text(4),last date)' at line 1
o Got request: SELECT player FROM pwdata WHERE player='Eliason' AND tag='Drax' AND name='demoName'
! SQL Error: Table 'nwn.pwdata' doesn't exist
o Empty set
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('Eliason','Drax','demoName','testValue',0)
! SQL Error: Table 'nwn.pwdata' doesn't exist
o Got request: SELECT val FROM pwdata WHERE player='Eliason' AND tag='Drax' AND name='demoName'
! SQL Error: Table 'nwn.pwdata' doesn't exist
o Empty set
o Disconnecting from database.

i think this is where i'm messing up in the instructions in aps/nwnx odbc documentation:
By default, it creates tables for the internal database. If you want to use MySQL instead, open the module with the toolset and edit the scripts "demo_createtable" and "demo_obj_create" accordingly.

i'm not very good at editing scripts , although i saw the demo_createtable script, i dont see anywhere the other script. Is it possible to get a mod. already configured to create a mysql database instead of the sqlite ?

i even tried this using the sqlite database (with the necesary changes to nwnx ini file) and it still didnt work for me.

[Papillon]

[Toro]

ok, i know this is really low level stuff but I have to ask
how do I comment out the sqlite and comment in mysql
I tried removing that /* before and after the mysql part abd i think that commented in the mysql because it turned blue, i then tried adding /* around the sqlite part to comment it out but it stayed blue.
btw I got the sqlite database working as it should =)
Once i get this mysql commented in, will it (like the sqlite) leave a mysql database in my nwn directory ?


void main()
{
SQLExecDirect("DROP TABLE pwdata");
SendMessageToPC(GetLastUsedBy(), "Table 'pwdata' deleted.");

// For SQLite
SendMessageToPC(GetLastUsedBy(), "Creating Table 'pwdata' for SQLite...");
SQLExecDirect("CREATE TABLE pwdata (" +
"player varchar(64) NOT NULL default '~'," +
"tag varchar(64) NOT NULL default '~'," +
"name varchar(64) NOT NULL default '~'," +
"val text," +
"expire int(11) default NULL," +
"last timestamp NOT NULL default current_timestamp," +
"PRIMARY KEY (player,tag,name)" +
")");

// For MySQL
/*
SendMessageToPC(GetLastUsedBy(), "Creating Table 'pwdata' for MySQL...");
SQLExecDirect("CREATE TABLE pwdata (" +
"player varchar(64) NOT NULL default '~'," +
"tag varchar(64) NOT NULL default '~'," +
"name varchar(64) NOT NULL default '~'," +
"val text," +
"expire int(11) default NULL," +
"last timestamp NOT NULL default CURRENT_TIMESTAMP," +
"PRIMARY KEY (player,tag,name)" +
") ENGINE=MyISAM DEFAULT CHARSET=latin1;");
*/

[Papillon]

you start a comment like this: /*
and you end a comment like this: */
(note the order)

Like this:

[Toro]

Thanks Paps !! You're the best and I appreciate your patience.
FYI I now have a Mysql database with 2 tables in it, as it should be !!
I knew those /* was the answer but i guess i missed the order of it last night.

Anyway on to the next step, which has to do with the query browser
I opened it, made nwn the default schema, saw my database there with the 2 tables. File>open query> navigated to my folder> changed that drop down box to any ansi so i can open the out.sql file> opened it.

It opened in that top window (took a cpl minutes). So now what ? How do i create those tables in nwn database.
I tried this : after it all opened in that top window, i hit execute.
i get an error near the bottom of the query browser stating
query returned no ruleset
unknown table prc_cached2da error nr 1051

I'm guessing that i'm getting this error because the tables arent there but isnt this suppose to create the tables ?

(later that day)
I tried this, instead of open query, i tried open script,, then loaded it. I think this worked because i see all the prc tables now along with pwdata and pwobjdata, This is correct right?

[Papillon]

If the PRC tables have been created, you should be set. I do not know if any data has to be written to those tables by the script as well, but at least it seems it passed without any errors. Good job !
_________________
Papillon

[Quadhund]

[Styxx42]

Toro for having the guts to ask these questions and and Papillon for having the patience to answer them.

YOU ROCK.

THANKS. I am at step one above but feel much more confident having found this thread.
I know squat about MySql but this GUI tool I just found because of this tread will help me progress further then I am right now.

Thanks again to you both.