Question about the Database CVS

[koldar]

Hello,
I am wondering a little bit about the database cvs. I just started looking around the peq_db and I am a little confused. Do I need to retrieve all of the sql scripts and execute them to run 7.0.992? I currently am running the peq database that is available from their site. Can someone help fill in the details for me? I have installed TortioseSVN, but haven't used a CVS before. If I do need to execute all of the scripts, does anyone know a fast way to execute all of them? Thank you for your help with my newbie questions.

Koldar

[cavedude]

run load_system and load_player.sql found on the CVS, exactly like in the older released package.

[rojadruid]

Originally Posted by cavedude

run load_system and load_player.sql found on the CVS, exactly like in the older released package.

They don't import into mysql 4.0.23 sadly. one of these days I should get a ver 5 server running.

[koldar]

I am having problems running the load_player.sql. At first, I had to remove the semi-colon from every line. Now it processes the first few lines then at it keeps giving me an error when it goes to load guild_members.sql and every .sql thereafter. Something about a syntax error. I am using the latest build of 5 for mysql.

[cavedude]

Both sourced just fine here using MySQL 5.0.27.

If you already have a database of the same name installed you have to run drop_player to remove accounts, toons, inventory, etc and drop_system to remove the heart of the database before sourcing in PEQ. Either that or create a new database. Whenever you upgrade PEQ you just need to run drop_system and then load_system.

[koldar]

I just down graded to 5.0.27 after reading the comments in the sql files. I am still getting many errors starting with guild_members.sql.

[koldar]

I complete recreated the peq_cvs database on my side and I was still receiving the error. In the load_player and load_system sql files I changed all of the "source" entries to "\." instead and it worked great. Thanks for the help! Hopefully I'll have my server running soon.