Nerdatorium: LAMP server

yes.



what flavor of L?

what version of A?

what version of M?

I don't know alot about P

I'm running Fedora 9 and and everything is what comes with the Fedora 9 distribution:

Apache - 2.2.9-1.fc9

MySql - 5.0.51a-1.fc9

PHP - 5.2.6-2.fc9



Would you be interested in helping to get this working so I could do the database conversion some time? I'd buy pizza and beverages.



What I need to do is upgrade the forums from an old version of PHPBB 2 to PHPBB 3. The necessary database conversion exceeds our hosting company's limits so I need to set up a server at home to do the conversion.

I'm willing to help, but about all I could do is eat your pizza, drink your beverages, and crack stupid jokes. Maybe you could consider it moral support. 😀

I can help, but it might be worthwhile to do it in steps.



Do you have the hardware already?



If not, I've got a linux laptop that we could use. Its a 1.7Ghz P4, but the drive isn't all that speedy.



I have a spare drive we could do whatever with.

Also, how much of this is a learning experience, vs a "just get it done" experience.



Both are valid. Stuff like this is a great chance to learn some mainstream tech, but if the goal is to just get er done...



I have zero time this week except for giveing out (bad) advice 😀

"Bender" wrote: I'm willing to help, but about all I could do is eat your pizza, drink your beverages, and crack stupid jokes. Maybe you could consider it moral support. 😀

x2

I've got FC9 running on a machine here at home. There's no real rush to get this done. My biggest unknown of the L, A, M & P is mysql. I work with ok with the hosting company and their gui interface, but on my server I just have the command line interface. I should probably look around for the gui to install at home.

"Dan-H" wrote: Also, how much of this is a learning experience, vs a "just get it done" experience.

Both are valid. Stuff like this is a great chance to learn some mainstream tech, but if the goal is to just get er done...

I have zero time this week except for giveing out (bad) advice 😀

I'm not in any rush. I started this a couple months ago and set it aside after installing the LAMP components.

checkout the bundled UI for mySql http://dev.mysql.com/downloads/gui-tools/5.0.html



I've used the adminstrator a little bit, the query browser a fair amount and never used the migration toolkit.

Another query tool I like is dbVisualizer.



http://www.minq.se/products/dbvis/download/index.jsp



There is a free version, that is bare bones.



The personal edition is alot better. you can get an eval license for the personal edition that's good for 21 days, at which time you need to get another eval via email.



the caveat on all this is I'm not a DBA I'm more of a user/abuser of the DB.

I checked our hosting company and found they use phpMyAdmin. I checked my server and I have it installed already. I just need to configure it.