|
It is currently Thu Nov 21, 2024 10:56 am
|
|
Page 1 of 1
|
[ 14 posts ] |
|
Author |
Message |
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
mySQL and phpBB
Oooooookay. First and foremost, i have absolutly no clue what i am doing.
I've come to the conclusion, that in order to have phpBB you must first have a working database of sorts, and decided i wanted to learn mySQL anyway, so i figured this is a good way to start.
I've downloaded mysql, to this directory:
C:\Documents and Settings\Steven Fellows\My Documents\web\mysql
all the files, including the different sized *.cnf files, are in this folder. I've read about custom installs moving these files to other places, but i'm trying to keep it simple.
I followed guide, as it's the simplest and most easy one to follow that i have come across.
I'll attatch my my.cnf as a .txt.
The problem, is the problem stated in the guide, the "Error 1067" but i can't see what i'm doing wrong, more to the point, i'm not sure i understand whats wrong. Any ideas/help/instructions would be much appreciated.
EDIT: I've noticed that the guide tells me to have a path to "ibdata" and "iblogs" yet these filers/folders (?) do not exist. What might they be? I notice it's "enqiuring" for a Dir, but does this just mean the directory in which this file is stored OR the location of this directory?
You do not have the required permissions to view the files attached to this post.
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Sun Apr 25, 2004 10:43 am |
|
|
Pig
Duke
Joined: Mon Mar 31, 2003 8:59 am Posts: 1358 Location: right behind you
|
Do you have a web server set up already? Honestly, I would make life easy on yourself. Go download on the all in packages that PHP, Apache and MySQL (and phpmyadmin probably too). That will install everything for you. If the php or mysql version are older, you can just download the update and should not have to configure anything. PHP Triad is what I have used, but it is no longer being supported and the PHP and mysql and phpmyadmin versions are all old. There are other packages out there though that have it all-in-one as well. Search around on download.com or google for it.
|
Sun Apr 25, 2004 3:11 pm |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
I'm guessing these are like... "auto edditors" for the coding etc? I'm gunna get one for the mySQL side of things, and learn the stuff aswell as i go.
Yeah, I've already got my server set up, see the link in my signature!
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Sun Apr 25, 2004 3:25 pm |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
this thing is fucking whack. I tried out the edditor on the MySql site, and it's shit. Non of it makes any sense, you change things, save it, and the changes just default to before the save...
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Sun Apr 25, 2004 4:35 pm |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
Oh, and BTW the properties for for each field is dumb. Because I'm assuming that enum means "from the following" eg, Yes or No? Mr, Miss, Mrs? etc. But anyway, you can set that and still type whatever the fuck you want in there.
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Mon Apr 26, 2004 4:26 am |
|
|
Pig
Duke
Joined: Mon Mar 31, 2003 8:59 am Posts: 1358 Location: right behind you
|
Mysql relies heavily on the logic coming from the programmer, which is part of why it is so fast. If you want something more compliant with ansi/iso, you should checkout postgresql.
As far as an admin program for mysql, I would use phpmyadmin. Very easy to use, and because it's web software, you can use it anywhere.
|
Mon Apr 26, 2004 5:51 am |
|
|
ElevenBravo
King
Joined: Wed Apr 16, 2003 2:18 pm Posts: 1976 Location: Sexy Town
|
Its really easier than you think.
If your doing this on your home computer then you need to complete the following steps.
#1 Install mysql
#2 Install Php (and make sure its working)
#3 Install phpbb ( the forums)
You cant do #3 until 1 and 2 have been complete and are working. Pig is right though, download that all in one package deal and its alot easier. Install Mysql really doesnt require much editing, but install php does.
http://www.mysql.com/
www.php.net
www.phpbb.com
To control mysql you this http://www.mysql.com/products/mysqlcc/
_________________ Contrary to popular belief, America is not a democracy, it is a Chucktatorship.
|
Mon Apr 26, 2004 5:53 am |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Mon Apr 26, 2004 7:01 am |
|
|
derf
Minor Diety
Joined: Fri Apr 11, 2003 2:17 pm Posts: 7721 Location: Centre of the sun
|
_________________ "Well a very, very hevate, ah, heavy duh burtation tonight. We had a very derrist derrison, bite, let's go ahead and terrist teysond those fullabit who have the pit." - Serene Branson
|
Tue Apr 27, 2004 7:57 am |
|
|
Satis
Felix Rex
Joined: Fri Mar 28, 2003 6:01 pm Posts: 16662 Location: On a slope
|
I got a question. MySQL. How the hell do you create users and stuff so I can start manipulating databaseS? I have it married to IIS on my work box (win2k).
_________________ They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
|
Tue Apr 27, 2004 3:21 pm |
|
|
Pig
Duke
Joined: Mon Mar 31, 2003 8:59 am Posts: 1358 Location: right behind you
|
|
Tue Apr 27, 2004 3:38 pm |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
Something tells me i'm going to have to do some basic MySql stuff to get a feel for this really. Is there good place to start? lol, like... what can i do with it? and simple step by step tutorials for begginers? I searched but couldn't find anything Decent.
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Tue Apr 27, 2004 5:19 pm |
|
|
Pig
Duke
Joined: Mon Mar 31, 2003 8:59 am Posts: 1358 Location: right behind you
|
mysql is nothing on its own. It is only used (and useful) with a programming language. PHP is my favorite. Check out sitepoint.com for an article by kevin yank. It is a good intro. phpbuilder and webmonkey also have good articles.
|
Tue Apr 27, 2004 6:39 pm |
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm Posts: 4004 Location: Walsall, West Mids, UK
|
_________________ Games to complete: GTA IV [100%] (For Multiplayer next!) Fallout 3 [50%] Rock Band [35%] http://www.cafepress.com/SmeepProducts
|
Wed Apr 28, 2004 5:55 am |
|
|
|
Page 1 of 1
|
[ 14 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 2 guests |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|