LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices



Reply
 
Search this Thread
Old 08-03-2003, 02:47 PM   #1
Phonics3k
Member
 
Registered: Jun 2002
Location: Wales, UK
Distribution: Gentoo 2005.1
Posts: 213

Rep: Reputation: 30
Question How to create a SQL Database in Linux?


How do you create a SQL database in Red Hat Linux 9 and host it on my site http://www.phonics3k.com so that I can use PHP to retrive data from it?

P.S Site Aint Finished.
 
Old 08-03-2003, 02:49 PM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,415

Rep: Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968Reputation: 1968
you install an SQL server like mysql or postgresql. Start it. Learn to use SQL....
 
Old 08-04-2003, 12:50 AM   #3
coolman0stress
Member
 
Registered: Jun 2003
Location: Toronto, Ontario, Canada
Posts: 288

Rep: Reputation: 30
That's right, get mysql/postgresql. Install it. Learn how to handle databases with PHP and some basic SQL. Now you are set.
 
Old 08-15-2003, 10:10 AM   #4
jdruin
Member
 
Registered: Jul 2003
Location: Louisville aka Derby City
Distribution: WinXP SP2 and SP3, W2K Server, Ubuntu
Posts: 313

Rep: Reputation: 30
To help you choose, I might suggest MySQL is more lightweight and somewhat easier to user because it cannot do as much as postgres. In its simplicity, you give up power, but the learning curve is less steep. Personally, I use postgres at home and DBA postgres at work (7.3.2). Its not bad after about 2-3 days of reading and you can make it easier by using tools like PGAdmin and others.

http://gborg.postgresql.org/browse.php?81
www.postgresql.org
 
Old 08-16-2003, 04:31 AM   #5
Robert0380
Guru
 
Registered: Apr 2002
Location: Atlanta
Distribution: Gentoo
Posts: 1,280

Rep: Reputation: 47
if you go with MySQL (that's what i use...and most books i see relate PHP to MySQL) make sure you configure php for mysql stuff. I think redhat does that automatically, or u can download an rpm what has it. if you want an easy way to manage databases, have perl installed with perl-DBI and download webmin from http://webmin.com
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restoring *.sql database from Linux Fedora's shell marciano Linux - Newbie 1 10-19-2005 07:05 PM
TOMCAT and MS SQL database shane200_ Programming 0 05-31-2005 11:52 AM
Is there a database manager for linux that is compatable with M$ Access and SQL? enigma Z Linux - Software 2 08-27-2004 09:50 PM
database needed not sql herc222 Linux - Software 3 03-08-2004 08:34 AM
SQL Database Administration GabeF Linux - Software 2 11-17-2002 08:28 PM


All times are GMT -5. The time now is 12:18 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration