database problem.. i think im slow oO

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

janiii wrote:run the .bat file from a command line window, so that when it closes the command line window will stay open.
how would i do that..
sorry i been up for 23hours the last 3 lookin around on the net for this fix :(
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: database problem.. i think im slow oO

Post by LasTravel »

tehmeat wrote:
janiii wrote:run the .bat file from a command line window, so that when it closes the command line window will stay open.
how would i do that..
sorry i been up for 23hours the last 3 lookin around on the net for this fix :(
Start>execute>cmd and drag the database_installer.bat to cmd window and press enter
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

LasTravel wrote:You are using windows server?

vars.txt are created on serverfolder/tools/ when you execute database_installer.bat, try execute it with right click > ejecute as admin
i dont see that txt file.. lol i dont kno what to say its not there

i did run as admin.. still closes :(
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: database problem.. i think im slow oO

Post by LasTravel »

Then create it, vars.txt with:

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysql.exeset mysqlBinPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\binset mysqldumpPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysqldump.exeset lsuser=rootset lspass=set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=set cbdb=l2jcbset cbhost=localhost set gsuser=rootset gspass=set gsdb=l2jdbset gshost=localhostset logdir=.set backup=.
If it don't work try put the patchs into a ""

And execute the installer...
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

LasTravel wrote:Then create it, vars.txt with:

Code: Select all

@echo off set config_version=2 set cmode=cset safe_mode=1 set mysqlPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysql.exeset mysqlBinPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\binset mysqldumpPath=C:\Program Files (x86)\EasyPHP-5.3.2i\mysql\bin\mysqldump.exeset lsuser=rootset lspass=set lsdb=l2jdbset lshost=localhost set cbuser=rootset cbpass=set cbdb=l2jcbset cbhost=localhost set gsuser=rootset gspass=set gsdb=l2jdbset gshost=localhostset logdir=.set backup=.
If it don't work try put the patchs into a ""

And execute the installer...
lol i just edited that myself i have now when i can start to load it.. but i get an error " there was some problem while executing ***mysql" -h localhost -u root --password= -e "CREATE DATABASE l2jcb" 2> NUL"
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: database problem.. i think im slow oO

Post by LasTravel »

You have created the database l2jcb?

If not, create it and ejecute again :D
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

it started then that came up.. i continue running the script and the error came up again then it said error occured while trying to create a database for ur login server.. i clicked c for continue and it just keeps going in circles
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

also the vars file is finally there.. :D
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

im not sure if its going to work or if im missing anything still
but i do see cbserver_back.sql and loginserver_backup.sql
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: database problem.. i think im slow oO

Post by LasTravel »

Maybe you don't have the databases, you need create 2 databases, l2jdb and l2jcb

PS: Don't make triple post or TPH will shoot your head, use the edit button ^^...
tehmeat
Posts: 14
Joined: Sat May 15, 2010 9:09 am

Re: database problem.. i think im slow oO

Post by tehmeat »

ok i have both databases set with navicat if thats what i needed to do.. but im still getting the same errors :(




P.S. woot its working.. after the vars file showed up i never cleared it out.. i just did so and it just ran the full install :D

P.S. thank u so much! u've been a huge help :D
Last edited by tehmeat on Sat May 15, 2010 11:12 am, edited 1 time in total.
User avatar
LasTravel
Posts: 888
Joined: Tue Jan 05, 2010 12:08 am
Location: Spain

Re: database problem.. i think im slow oO

Post by LasTravel »

Okay, welcome to l2j!
Onepamopa
Posts: 113
Joined: Thu Jan 14, 2010 6:35 pm
Contact:

Re: database problem.. i think im slow oO

Post by Onepamopa »

Note to windows users: try to avoid installing mysql, & l2j server in directories with spaces, sometimes they can cause issues :)
----------------------------------------------------
ICQ: 287731217
Skype: d.i.dobrev
IRC: Onepamopa
----------------------------------------------------
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Re: database problem.. i think im slow oO

Post by MELERIX »

Onepamopa wrote:Note to windows users: try to avoid installing mysql, & l2j server in directories with spaces, sometimes they can cause issues :)
My L2J server, Java & MySQL are in directories with spaces, and nothings happens, all is working fine.
iltrida
Posts: 1
Joined: Sun Jun 29, 2008 4:13 pm

Re: database problem.. i think im slow oO

Post by iltrida »

I have had the same problem with database_installer. I put the full path in mysql "set" (all 3 of them) into var.txt, and surprise! the program go on :)
Post Reply