[GUIDE] How to set up L2J server without MySQL server

[Horizons]

Hey Guys

 

I know many people who have problems with configurating the MySQL server, becouse of this I have decided to make a tutorial, in which i will show you how to set up a L2J server without MySQL.

 

ATTENTION: THIS IS NOT A FULL GUIDE IT'S ONLY A EXTENSION TO THE NORMAL GUIDE!!

 

first some things i want to say:

1.I'm 17 years old an go to school, my englisch is not perfect! please don't critizise my englich skills!

2. This is my first tutorial, but I will give my best to write correctly and explain it as good as I can.

3.This is not a Funtopic,it is possible to set up an L2J server without MySQL server

4. in this tutorial I will use L2J Interlude

 

Ok let's start.

 

First of all you will need

xampp

then you will need

Navicat

and then the Interlude or other L2J packs.

 

If you have download xampp, you have to install it.

Choose you language, and follow the instructions.

When the Setup finished look on your Desktop, you will have an xampp shortcut there.

Open Xampp and Start Apache & MySQL, Now tick the box SVC on the Left of MySQL.

 

Xampp includes his own MySQL server this is the reason, why you Don't need to Download MySQL.

Xampp has setup you MySQL server with the Default configuration "root@localhost" use Password NO

 

seems your loginID is root and a PW is not set.

 

now you have to install Navicat:

Open Setup.exe and follow the instructions.

After you have installed Navicat you have to create a new Connection

 

 

Type 'Localhost' in the field: Connection Name

 

DONE!

 

now Extract the L2J packs in a folder and go to 'tools' and start database_installer.bat

 

Now the Funny part begins:

 

You have to Change the MySQL path to the Path of xampp.

 

Still type 'C:\xampp\mysql\bin' and press enter

 

Then set the configuration like in the picture below:

 

 

Now the database will be installed

 

Following steps will be explained HERE

 

if you follow my instructions you wouldn't have problems with set up L2J server

 

I hope this will help some people who have problems with MySQL!

 

Greetz

Horizons

[An4rchy]

so what's the point to do that?

 

 

thx anyway.

[Sick]

I wanted something alternative because MySQL isn't working on my pc,thanks

[xuinia]

You wanted alternative for MySQL so you decided to use MySQL??? You just instaled same MySQL just it was included in xampp package. You're still using it, so this all "GUIDE" makes absolutely no sence.

[Zeeyo]

  On 1/29/2011 at 10:07 AM, xuinia said:

You wanted alternative for MySQL so you decided to use MySQL??? You just instaled same MySQL just it was included in xampp package. You're still using it, so this all "GUIDE" makes absolutely no sence.

 

@xuinia:

Posting spam is not tolerated in these forums.

 

On topic:

I have heard that, at least in earlier xampp versions, the MySQL is configured either in aggressive mode, which may cause CPU spikes whenever MySQL service is not idle, or in regressive mode, which provides really, really low performance, which is generally unacceptable in l2j.

Care to elaborate?

 

@an0s:

If MySQL did not work, xampp will not work as well.

Only if you knowingly messed up MySQL installation, only then xampp will work.

[Sick]

  On 1/29/2011 at 10:43 AM, Zeeyo said:

Only if you knowingly messed up MySQL installation, only then xampp will work.

Yes i messed up the installation now i can't install it

[xuinia]

  On 1/29/2011 at 10:43 AM, Zeeyo said:

@xuinia:

Posting spam is not tolerated in these forums.

What I wrote has nothing to do with spam.

Topic says: How to set up L2J server without MySQL server

And inside topic he explains how to set up a server by using MySQL...

xampp is a package, containing apache + php +  MySQL. So he's still using same mysql, just it is installed by xampps installer.

[Horizons]

  On 1/29/2011 at 12:21 PM, xuinia said:

What I wrote has nothing to do with spam.

Topic says: How to set up L2J server without MySQL server

And inside topic he explains how to set up a server by using MySQL...

xampp is a package, containing apache + php +  MySQL. So he's still using same mysql, just it is installed by xampps installer.

sry maybe I have say it with wrong words. I mean how to set up l2j without MySQL server 5.1 (the programm)

xampp contains mysql , thats right but it's much easier to install and configure. that what I meant.

 

Thats why I decided to make the guide

 

and btw. If Mysql server 5.1 Doesnt work, you can unistall it and & install xampp. Xampp will set all mysql settings to default.

 

In any case it works at my PC. And I think xampp is a good alternative to MySQLserver 5.1

[likerboy]

  On 1/28/2011 at 10:01 PM, an0s said:

I wanted something alternative because MySQL isn't working on my pc,thanks

 

like me:D now i can make a l2 server Good Post Man!!!!!!:)

[DarthVader]

I thought, you will use something like xml files as database or else, but nah. :D

[HaxFixer]

xampp give you ability to make website throught apache and it will work fine with the mysql. Nice share anw i used it long time ago :)

[SoRa]

Very useful guide bro,gratz and keep sharing.

[HellRuLeR]

useless for me but thx anyway!

[ArkeyWave]

At least to me this is completely USELESS, since having some programs in one package. would make you risk to have a facked up config [some crashes too], you will always run that risk because you do not know when all the process on xampp [shitty program like wamp (that's what i think)] will crush and make a mess.

About using this, might be ENOUGHT [only that] if you are testing yet, with your friends are finding bugs, and so on, but for a live server, i will never recommend this, if you want to have a server performancing well, you need to use mysql community board [from official site].

 

P.S. I read few people said that have messed their mysql so didn't know what to do to make their server .. well about that, you just need to clean your computer, going to delete ghost files [hidden and missing to be deleted ones] and deleting that from services list, and one more thing, installing that with another service name [not mysql anymore, for example use any of the other options like mysql55, mysql5, mysql5.1 and so on].

 

Thanks for sharing this guide, i aprecciate the time you have spent to make this, but remember one thing, althought be difficult to clean your computer to back to use mysql [official one], will be better for a better performance.

 

Greets ;D

[HellRuLeR]

  On 3/2/2011 at 7:02 PM, HighOne said:

At least to me this is completely USELESS, since having some programs in one package. would make you risk to have a facked up config [some crashes too], you will always run that risk because you do not know when all the process on xampp [shitty program like wamp (that's what i think)] will crush and make a mess.

About using this, might be ENOUGHT [only that] if you are testing yet, with your friends are finding bugs, and so on, but for a live server, i will never recommend this, if you want to have a server performancing well, you need to use mysql community board [from official site].

 

 

P.S. I read few people said that have messed their mysql so didn't know what to do to make their server .. well about that, you just need to clean your computer, going to delete ghost files [hidden and missing to be deleted ones] and deleting that from services list, and one more thing, installing that with another service name [not mysql anymore, for example use any of the other options like mysql55, mysql5, mysql5.1 and so on].

 

Thanks for sharing this guide, i aprecciate the time you have spent to make this, but remember one thing, althought be difficult to clean your computer to back to use mysql [official one], will be better for a better performance.

 

Greets ;D

maybe it is useless for you but usefull for sb else...But you have to respect other ppls work anyway...Express your feelings in a better way.Anyway it's helpfull for these who have probs with mysql.....