Hi Lee,
I run a system just about like you're talking about. I run an Apache server with PHP and a MYSQL database. I am not using the database logging right now, but I might add it a little later. I did run mysql 4.* and I had no problems with it, but I had some issue that I needed to upgrade something. I really don't remember what the problem was, but I found out that if I upgraded one, then I would have to upgrade the others also. To take the easy way out I found a package called LAMPP (Also known as XAMPP) that contains the v5.0.15 of mysql vers 4.* and 5.* of php and Apache 2.0.55. So you might want to check on the version dependencies before you actually decide on which version you get.

---

Jim

Some people plan their life out and look back at the wealth they've had.
Others live life day by day and look back at the wealth of experiences and enjoyment they've had.

If you are used to object oriented programming or know what BNF is try v5 of MySql.

well i know virtually nothing of application programming, and don't know what BNF is, so in that case are you advising that i start with v4?

...visit Amazon.com and spend just a few bucks on an Orielly MySQL book.

oh yes, i intend to do lots of reading before doing anything major, i know what you mean about saving yourself time in the future from past experience with web development (when i was learning)

---

Want to search the BOINC Wiki, BOINCstats, or various BOINC forums from within firefox? Try the BOINC related Firefox Search Engines

If you are used to object oriented programming or know what BNF is try v5 of MySql.

I also advise you to visit Amazon.com and spend just a few bucks on an Orielly MySQL book. Most DB programmers carry a library of books and use them everyday. I find it saves me from those "4 hour long problems, that have no solution". :)

---

Overclock with the MSI G31M3-L and Intel E8600 3.33Ghz
Intel D865GLC Socket 478 Motherboard
~How To Overclock The Eee ASUS 1005HA Netbook To 1.9Ghz~

I moved BOINCstats from MySQL v4 to v5 without any recoding, so I don't see much problems with a transition (but it may be the type of queries I use).

that's good to know, i assume that's by using good coding with more "universal" queries

If you're new to MySQL then why not start with v5?

that's what i was thinking, especially if there's not much difference compatibility-wise i don't see a whole lot of point learning an old version, but it might be a good idea starting with what i assume to be a simpler v4, then upgrading to v5 rathe r than jump straight in with all the new features i won't understand (which, as with most things, are only apparent once you realise the problems with the old verison and have used it for a bit)

---

Want to search the BOINC Wiki, BOINCstats, or various BOINC forums from within firefox? Try the BOINC related Firefox Search Engines

I moved BOINCstats from MySQL v4 to v5 without any recoding, so I don't see much problems with a transition (but it may be the type of queries I use).

If you're new to MySQL then why not start with v5?

---

Join team BOINCstats

"generally" MySQL 5.x is more "object oriented"... Sorta like C++, so a large number of existing apps and PHP were not current for 5.x. So some of the things I do currently became "frozen" in time...

oh i see

well as i'm starting without any previous experience would that matter?
or do old SQL queries not work with v5?
one of the things i wanted to do was have my IIS (but planning to move to apache soon) server enter it's access log data into a DB table rather than text files
also have the new (still in beta) boincview log WUs in a table rather than a CVS file or it's own SQL database, but i assume it depends if the SQL queries are the same or not

keep in mind i'm a beginner, so you'll have to keep in it relatively simple terms lol

---

Want to search the BOINC Wiki, BOINCstats, or various BOINC forums from within firefox? Try the BOINC related Firefox Search Engines

Lee

"generally" MySQL 5.x is more "object oriented"... Sorta like C++, so a large number of existing apps and PHP were not current for 5.x. So some of the things I do currently became "frozen" in time...

thanks Al :)
the PHP isn't a problem, my web server will handle that (already installed on it)
the "new" machine will just be handling MySQL

Stay away from the 5.x versions... Go with 4.x versions of MySQL.

could i ask what makes you say that? is v5 worse? does it require more in the way of resources than that little box can give?

Al

---

Please consider a Donation to the Seti Project.

thanks Al :)
the PHP isn't a problem, my web server will handle that (already installed on it)
the "new" machine will just be handling MySQL

Stay away from the 5.x versions... Go with 4.x versions of MySQL.

could i ask what makes you say that? is v5 worse? does it require more in the way of resources than that little box can give?

---

Want to search the BOINC Wiki, BOINCstats, or various BOINC forums from within firefox? Try the BOINC related Firefox Search Engines

Lee

The G1 with 256 will run MySQL and PHP it has enough memory... Stay away from the 5.x versions... Go with 4.x versions of MySQL.

I'm wanting to learn about databases and SQL etc. (to eventually lead to some PHP web development too)

i've got a spare dell optiplex G1
which has a PII 350MHz CPU with 256MB of RAM

would that be able to copy with an installation of MySQL running on it?

i hope to eventually use it for practical things, like logging software events (rather than logging to text files) and to drive parts of my website etc. so would that spare optiplex be able to cope with that kind of load as well (i only run a small personal website by the way)

many thanks for and help as i couldn't find much helpful info on the official site

Al

---

Please consider a Donation to the Seti Project.

I'm wanting to learn about databases and SQL etc. (to eventually lead to some PHP web development too)

i've got a spare dell optiplex G1
which has a PII 350MHz CPU with 256MB of RAM

would that be able to copy with an installation of MySQL running on it?

i hope to eventually use it for practical things, like logging software events (rather than logging to text files) and to drive parts of my website etc. so would that spare optiplex be able to cope with that kind of load as well (i only run a small personal website by the way)

many thanks for and help as i couldn't find much helpful info on the official site

---

Want to search the BOINC Wiki, BOINCstats, or various BOINC forums from within firefox? Try the BOINC related Firefox Search Engines