Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows)

[drognir]

At this step

16) Then source the following databases into the database by typing the following commands(In this order)
Code:

Source load_system.sql; Source load_empty_users.sql; Source items-0.6.0-DR2-0.6.1-DR1-convert.sql; Source 0.6.1-upgrade.sql; Source ZONECFG.SQL; Source altadv_vars-contents.sql;

i am getting this error

mysql> source load_system.sql;
ERROR:
Failed to open file 'load_system.sql', error: 2
mysql>

I'm sure that i'm doing something totally noobish, and that this error is easily fixed. If anyone could help me i'd really appreciate it thanks.

[Aradorn]

did you make sure all those files are in c:\mysql\bin folder. make sure there are no folders inside the bin

[Aradorn]

iwantavr4 do you have EQVercheck if you do can u post your version i want to make sure mine matches i didnt patch on 5/11 but i did patch up to 5/11 and i want to make sure my version matchs befor i continue

[drognir]

I think that's the problem, those first two files don't exist.

Source load_system.sql;
Source load_empty_users.sql;

I didn't see anywhere in the tut where it says to download them.

[Aradorn]

those files are in the peq-velious-beta1.zip

[drognir]

Thanks . I noticed when i extraced the velious db that there was a directory in the zip file, and the tut didn't mention anything about not leaving it there so i just extracted the directory. I really appreciate the help.

[Aradorn]

this is my eq version pre 5/11 just wondering if this is the right one to work with the 6.1dr1
SHORT VERSION: SEQ8A667
LONG VERSION: EQ10F6C5D8579C384AAACC9FA61E2727A6B8291587

[vRandom]

thats the same eq version i have that works with this tutorial

[vRandom]

Velious beta Database from PEQ
http://prdownloads.sourceforge.net/p...ious-beta1.zip

then extract them in step:

Extract the following database files to C:\Mysql\bin
8a) peq-velious-beta1.zip



Used this tutorial and everthing works execpt the merchants
i did get 2 beeps on the Source load_system.sql but it scrolled by so fast i wasnt able to find out what caused the beeping...

[edit] Aradorn types faster than me

[Mossfiend]

Will this guide allow me to host my own server so that I can play without being on the internet, and my brother or friends could connect to me via lan, and also play the game?

If not, is there any way I can go about doing that?

[devlor]

Great work iwantavr4! Using your guide I was able to get the new version (I've been away for awhile) set up without a hitch. Thanks for all your hard work and for sharing all of this with us here.

BTW, someone earlier in this thread posted a problem where their character was stuck in an endless zoning loop. Even though someone else helped them out, I thought I'd mention that you can use the in-game #movechar [character name] [zone short name] command with a different character to move another you're not logged in with. I keep a separate "GM" character camped out in a safe zone specifically for this purpose.