an installer

[clayton491]

i noticed that lotgd v9.7 did not come with and installer only the sql info. i think that they should come with an installer to

[MightyE]

A phpBB style installer is something we've thought of, but have honestly felt our efforts so far were better spent on in-game feature implementation than elsewhere. It's possible 0.9.8 comes with an installer, though I won't promise anything in that regard.

[clayton491]

well with out the installer then how do you set up the tables?

[Talisman]

Copy the text from the sql file from Sourceforge. Create an empty database in mySQL. Paste it into an sql command window in your mySQL interface, then click on 'go'. It will create the tables and populate the fields.

[clayton491]

umm ok could you be more specific out how to Create an empty database in mySQL. Paste it into an sql command window in your mySQL interface, then click on 'go'. It will create the tables and populate the fields.

[Talisman]

How you create an empty (new) database in mySQL all depends on what your interface is. Look for something that indicates "Create Database"; create the database.

When you're working with the interface with a database selected, you should see a text edit box indicating "Execute SQL commands" or something like that.

It's all fairly straight forward, but you might need to examine your interface and do a bit of manual reading if you're lost in it.

[clayton491]

ok is there anything i need to set up the database and execute the sql comands

[Talisman]

Let's back up a bit. Are you trying to set this up on your own computer, or on a webhosting service? Do you have php support and a mySQL database? What program do you have as an interface to your database?

[clayton491]

my site is beening hosted yes it supports mysql and php but i didnt know i needed any program

[Talisman]

The necessary tools should be in your webspace...you've got a Control Panel of some sort, ie Cpanel X. If you are allowed to have more than one mysql database, you'll find a link to something like "Manage MySql" or something of the sort. You create your database in there. All you have to do is create it - give it a name. You don't need to define anything there.

You should also have a program, probably phpMyAdmin. Open that. In the left side where it says database, drop the list and select your database.
Find the tab that says SQL and click on it. Copy the entire text from the sql file and paste it into the editing window, or use the browse feature to point to the file on your local hard drive. Click go.

Don't forget you will need to configure your dbconnect.php file with unique access info.

[clayton491]

ok but dont you kneed forums for phpmyadmin to work

[Pavarotti]

you should have some form of database control panel where you can add/see/edit databases and create/edit users and hopefully phpmyadmin will be available from there (for every database you have - forums is separate software and phpmyadmin has nothing to do with it.

Some forums if not most of them does have a database cp (for the forums only) but the ones I have seen does not use phpmyadmin

[clayton491]

ok where do i get phpmyadmin

[Talisman]

Your webhost should have it set up for you. You cannot set it up on your host yourself. I would suggest you slow down a bit, and read the documentation that your webhost provided to you - it should answer many of your questions.

If you are unclear as to how to access and administer your mySQL database, and cannot figure it out from your host's documents/FAQ's you should check their support areas or submit a trouble ticket to them asking for guidance.

By the way - with the questions you've been asking, you wouldn't have been any further ahead of where you are now even if there was an installer... :wink:

[neXus]

actually, given your mysql username, host and password, you can install phpmyadmin and similar things yourself... You can then use that to set the rest up... Phpmyadmin itself is nothing but an sql client frontend for php...

[Talisman]

Very true, Nexus. Most hosting packages that provide mySQL provide some form of interface for managing SQL, usually phpmyadmin. Based on his questions, I suspect his best route would be to read his server's FAQs, and contact them for assistance.

How are you making out on this, clayton?

[GenmaC]

I had to setup phpmyadmin for my server, which I got from chambergates.com. As long as you have access to mysql, it shouldn't be too hard.