Setting up a Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Zorth
Forum Commoner
Posts: 76
Joined: Fri Feb 20, 2004 8:00 pm

Setting up a Database

Post by Zorth »

Hey all,

This may seem really stupid, but I'm struggling to set up a MySQL database for a forum I want to put up. I wanted to put up a version of phpBB forums that I had before(I had someone walk me through before, but for the life of me, cannot remember how to do it), and on a Windows system. I downloaded MySQL, but I believe you have to go into the program and enter some commands to get it working? I really cannot remember.

I have PHP installed, as well as Apache, so I assume I just need to get mySQL working before I can get these forums up... I also have phpMyAdmin page, but I'm not really sure how to go about getting MySQL to work in there either.

Any help is appreciated.

Zorth the n00bie.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

Well if your on windows to install mysql its basically just a case of running the installer, and then double clicking on tthe .exe file to make it run. This should be in the bin directory where you installed mySQL. If it says its not running then double click the winmysqladmin and ensure that you get a green light on the traffic light icon. When its running you need to test to see if it is all working by running phpMyAdmin and ensuring that there is no problems.

When you get to this stage you can use phpMyAdmin to create the database and it should be simple from then on to set up phpBB.
Zorth
Forum Commoner
Posts: 76
Joined: Fri Feb 20, 2004 8:00 pm

Post by Zorth »

What if the phpBB forums were old, and all I saved were the web files? Would that mean that I lost all of the databse information? I never really understood WHERE it saved its files...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

yes, you lost all the actual forums and settings for phpBB.
Post Reply