(MySQL) What version is best and where to find it?

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
BlazinSpitfireX
Forum Newbie
Posts: 6
Joined: Sun May 16, 2004 11:17 pm

(MySQL) What version is best and where to find it?

Post by BlazinSpitfireX »

Hey again. I finaly am all set to make a forum and I come across the problem of finding what verion of SQL is best, where to find it, and how much is it. I did do research before comin to ya'll and I still can't find the info I want. I went to SQL homepage and read the whole damn tutorial (one day wasted) and it didn't do anything for me. This would help alot and i'm happy with any help I can get. Thanks, later.
Unipus
Forum Contributor
Posts: 409
Joined: Tue Aug 26, 2003 2:06 pm
Location: Los Angeles, CA

Post by Unipus »

Are you asking what version of SQL is best, or what version of MySQL is best? There's a big difference.
BlazinSpitfireX
Forum Newbie
Posts: 6
Joined: Sun May 16, 2004 11:17 pm

Post by BlazinSpitfireX »

Theres a diffrence?...I really don't know servers. The one best for hosting a small PHP forum, which ever that my be.
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post by delorian »

SQL -> Structured Query Language
MySQL is Relational Database Management System http://mysql.com
BlazinSpitfireX
Forum Newbie
Posts: 6
Joined: Sun May 16, 2004 11:17 pm

Post by BlazinSpitfireX »

thanks :D . sept now I need to figure out how to upload the forum archive. I open the WinMySQLAdmin and then...*confused*. Any help is appreciated. Thanks again.
Unipus
Forum Contributor
Posts: 409
Joined: Tue Aug 26, 2003 2:06 pm
Location: Los Angeles, CA

Post by Unipus »

There's a lot of different SQLs. MySQL, MS SQL, PostgreSQL, etc. For a small project like this, MySQL should be fine. A lot of people are now prefering the equally free Postgre for more ambitious projects.

To answer your question, it would be helpful if your archive file was in the form of an SQL schema. Then you could just copy and paste the commands into MySQL and watch it go.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Why not have a database abstraction layer (or database wrapper) which would make you DB-independent? PEAR::DB is certainly up to the job, and adoDB more than that.
Post Reply