Page 1 of 2
Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 5:10 pm
by ksmxbg
What MySQL needed for setup new clean Freya server ?
in Wiki its writen to i must use xampp for linux. Can I use mysql-server builded-in in ubuntu packages (from Ubuntu Software Center as example), or any other version ?
Or its a must for L2J to i use xampp ?
thanks
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 5:33 pm
by jurchiks
What fool said you need xampp?
You don't need neither Apache or PHP to run l2jserver. I'm not sure about the Ubuntu built-in packages, but read my signature.
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 5:38 pm
by Sleek
Just install mysql-server from respisotory
That's all you need, then just start configuring it...
If you want to have it visually I recommend phpmyadmin and for that you need apache2
Code: Select all
aptitude install phpmyadmin apache2
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 5:52 pm
by ksmxbg
thanks for answers
jurchiks wrote:What fool said you need xampp?
http://www.l2jserver.com/wiki/index.php ... r_-_Ubuntu
in this guide, ill install lampp (commonly called xampp too, "l" for linux)
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 5:57 pm
by ksmxbg
jurchiks wrote: but read my signature.
so i do all of ur sig

but server works with lampp and with build-in, i'm just amazed what to delete and with what will be better
so thanks again and i will be glad for any other suggestions for choice of sql for Freya
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 6:02 pm
by Sleek
ksmxbg wrote:jurchiks wrote: but read my signature.
so i do all of ur sig

but server works with lampp and with build-in, i'm just amazed what to delete and with what will be better
so thanks again and i will be glad for any other suggestions for choice of sql for Freya
Since you are running ubuntu I firstly suggest yo update to 10.10.
And my 2nd suggestion is to use mysql-server with phpmyadmin if you want visually. Lamp is no good for this purpose.
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 6:07 pm
by jurchiks
That doesn't mean you have to do exactly the same. Instead of installing xampp, install just mysql.
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 6:59 pm
by ksmxbg
thanks 4 all and it's not important but why msql-server from Ubuntu packages is better from lampp ?
Sleek wrote:Since you are running ubuntu I firstly suggest yo update to 10.10
10.10 have problems with Intel graphic drivers, it's solved in 11.xx (i first test serv/client on one machine)
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:00 pm
by Sleek
ksmxbg wrote:thanks 4 all and it's not important but why msql-server from Ubuntu packages is better from lampp ?
Sleek wrote:Since you are running ubuntu I firstly suggest yo update to 10.10
10.10 have problems with Intel graphic drivers, it's solved in 11.xx (i first test serv/client on one machine)
Why would you use GUI for linux server?
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:09 pm
by jurchiks
Uhh... linux doesn't mean you absolutely have to use console only.
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:34 pm
by Sleek
jurchiks wrote:Uhh... linux doesn't mean you absolutely have to use console only.
It does not but then you might as well use windows server if you are going to use GUI for your server. You lose performance from GUI.
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:42 pm
by ksmxbg
Sleek wrote:Why would you use GUI for linux server?
GUI it's not bad , but terminal is no problem (i was born on terminal

but this is other topic )... just for protocol lets we talk what is best for Freya
thanks
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:54 pm
by jurchiks
Sleek wrote:It does not but then you might as well use windows server if you are going to use GUI for your server. You lose performance from GUI.
You might lose server peformance, but not your own. Also you can do many things with GUI faster than without, and you can disable it when you don't need it, so...
You can disable GUI on windows too, just end explorer.exe and run cmd.exe and go ahead. But is it more comfortable?
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 7:59 pm
by ksmxbg
so gui or cmd .. lets all use what they like more ...
anyway SQL Server version: 5.1.49-1ubuntu8.1 (Ubuntu) it' okay for Freya ? and what about versions of SQL Servers, are they good to be latest, or you can recommend me specific version that is the best one ?
Re: Freya SQL choice - Ubuntu 11.04 ?
Posted: Thu Dec 30, 2010 8:01 pm
by Sleek
ksmxbg wrote:so gui or cmd .. lets all use what they like more ...
anyway SQL Server version: 5.1.49-1ubuntu8.1 (Ubuntu) it' okay for Freya ? and what about versions of SQL Servers, are they good to be latest, or you can recommend me specific version that is the best one ?
Use latest sql server.