Welcome to PB forum! If you are a gamer feel free to register and join the fun! We have all the games you need to talk about. So register and have fun!
 
HomeDonate to PB!FAQMemberlistUsergroupsRegisterLog inCalendar

Share | 
 

 How to setup a SQL Database!

Go down 
AuthorMessage
Jecce
Member
Member


Posts : 8
Points : 16
Reputation : 0
Join date : 2011-10-27

PostSubject: How to setup a SQL Database!   Thu Oct 27, 2011 4:41 am

Hello.

I am now going to show you how to setup a MySQL database.

Why use Uniform Server instead of XAMPP?
1. Security
2. Lightweight (xampp 51MB, XAMPlite 28MB. Uniform Server 8.75MB).
3. Easier to use.
4. XAMPP got lots of unnecessary features, especially for the Open Tibia community. Despite the small size of Uniform Server, it has all we need.

Installing Uniform Server will give you:
MySQL database.
phpMyAdmin to administrate the MySQL database.
Apache hosting.
PHP 5.3.5+
eAccelerator to make website faster.

XAMPP + Modern AAC = Page rendered in: 0.0554 seconds.
Uniform Server + Modern AAC = Page rendered in: 0.0219 seconds.

Do I need to say more? So lets get started!

Things required.
Uniform server.
A server. recommended Mystic Spirit.


LETS GO!

When running the program, it will ask to install it to something bothersome like:
C:Usersprogram files
or something similar.

Don't install it there, you can do it, but windows filesystem is crap so we want to save it as close root as possible.

So install it directly to
C:


And click Extract.

Installation complete. That wasn't so hard?

But we still need to learn to configure and use it, lets get to that now:

Click Start.

Whohaw! You started it!

OMG! POPUP MSG; your computer will crash

Just kiddin.

The message simply says there will be an icon at the bot, the icon with "1".

That little icon is the configuration panel of Uniform server.

Right click = Services
Left click = Start without running as services.

Services = It will start automatic, if you restart your computer, it will automatic restart so you won't have to click "start".

start and Stop UniServer = start and stop the website and Mysql database.

If you click on Stop while your OT server is running your in problems. Since you close the MySQL database. So don't do that while OT is online!

What else is useful is phpMyAdmin, click on it and you will connect to phpMyAdmin, so you don't need to remember the address.

Now start uniserver, and click "Admin Panel"


And then you should fix your security, for avoidance of hackers.

Then go to 127.0.0.1 and log in with
root/"yourpassword"


Ok.

Now you should be at your panel.

Then create a database.

->IMPORT then click choose file or browse.

-> go to your server. -> Mystic Spirit/schemas. Then open mysql.sql

then you have a fully working database, comment, rate. Repp <3
Back to top Go down
Jimbo
Moderator
Moderator
avatar

Posts : 21
Points : 34
Reputation : 7
Join date : 2011-10-25
Location : United States

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 4:44 am

Very nice tutorial. Thank you for contributing.

_________________
If I helped you, add reputation. Please.
Back to top Go down
Jecce
Member
Member


Posts : 8
Points : 16
Reputation : 0
Join date : 2011-10-27

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 4:51 am

Thank you.

You will be seeing much more from me Smile
Back to top Go down
Ympker
Moderator
Moderator
avatar

Posts : 21
Points : 30
Reputation : 1
Join date : 2011-10-21

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 4:51 am

Nice tutorial,
thanks for sharing it with us Very Happy

_________________
add me! cheers, to :
LOL-->Ympker
otland friendslist-->Damon
open-tibia.de-->Ympker
Combat Arms-->JamesRyanPro
Minecraft-->Ympker
otfans-->Ympker

THE RETURN OF THE king
Back to top Go down
Zatjin
Moderator
Moderator
avatar

Posts : 24
Points : 41
Reputation : 3
Join date : 2011-10-22
Age : 19
Location : Norway

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 4:52 am

Holy shait!

That's a really good tutorial!

Really, thank you for contributing!

Sincerely,
Zatjin
Back to top Go down
Jecce
Member
Member


Posts : 8
Points : 16
Reputation : 0
Join date : 2011-10-27

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 4:55 am

Thank you so much!

So bad this forum ain't got many members.

I've been watching this for like a day or so, and I decided to join Smile

Lol, I have to stay on-topic Smile
Back to top Go down
Ympker
Moderator
Moderator
avatar

Posts : 21
Points : 30
Reputation : 1
Join date : 2011-10-21

PostSubject: Re: How to setup a SQL Database!   Thu Oct 27, 2011 7:25 am

There will come more members! I belive in that, and if not belive in it, what do else?!Twisted Evil

_________________
add me! cheers, to :
LOL-->Ympker
otland friendslist-->Damon
open-tibia.de-->Ympker
Combat Arms-->JamesRyanPro
Minecraft-->Ympker
otfans-->Ympker

THE RETURN OF THE king
Back to top Go down
Sponsored content




PostSubject: Re: How to setup a SQL Database!   

Back to top Go down
 
How to setup a SQL Database!
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Public-Gaming :: PC :: Tutorials-
Jump to: