harriyott.com

Sunday, May 14, 2006

I feel really thick tonight

I've inherited a client's PHP / MySQL / PHP Nuke website, and I've not used these technologies before (I'm a .NET / SQL Server guy). I successfully installed PHP and MySQL a couple of weeks ago (older versions, it seems), and downloaded the source from the web server. I managed a database backup from the server too (there was an option on the PHP nuke admin page).

Tonight I've been trying to actually get the thing running, having no idea where to start. I don't know the simplest things about MySQL, like where do I type the SQL? What is the equivalent of Enterprise Manager? I've answered the first, and hopefully not answered the second. Usually with software, I can download it, fire it up, and make a pretty good guess of how it works. This time I've had to read the manual quite a lot, which I guess is a good thing.

Anyway, I've just restored the backup onto my installation, and I've got a different PHP error, so I've clearly been successful. Now I've just got to fix this error, and see what happens next. When I actually get this all running, then I can start making it look pretty.

[Tags: ]

posted by Simon at 9:26 PM. Permalink  

5 Comments:

Helephant said...

MySQL comes with a command line tool that you can directly put SQL commands into (bin/mysql). I think the latest version also comes with a GUI tool that's a bit like enterprise manager. I don't know if it'll work with the version you've got, but it's one of the ones under tools on this page:
http://dev.mysql.com/downloads/

There's also a pretty good web based tool called PHPMyAdmin which is what most people I know use:
http://www.phpmyadmin.net/home_page/index.php

I grew up on MySQL and PHP so feel free to email me (helen@helephant.com) or IM me (blue_helephant@hotmail.com) if you run into anymore problems. :)

May 15, 2006 11:44 AM  
Simon said...

Bless you Helen, that's really helpful. I've just had a quick look at the links, and they look ideal. I'll download them later on in the week when I get a free evening. Thankyou.

Will I see you at DDD3? Sorry, I didn't get round to reminding you before it sold out.

May 15, 2006 10:18 PM  
Helephant said...

Unfortunately not. We get back from Australia about lunchtime on the day that it happens. I'll have to ask the organisers to be more mindful of my holidays next time. :)

May 15, 2006 10:33 PM  
Helephant said...

Speaking of DDD3 though.. did you end up submitting a talk?

May 15, 2006 10:34 PM  
Simon said...

Shame. They already moved it once to avoid the football. Maybe they'd move it again...?

I did submit a talk, entitled "Building a build machine for daily builds with MSBuild". Guy Smith-Ferrier submitted an almost identical talk, but neither of us were amongst the chosen ones. I'm slightly disappointed, but actually quite relieved.

May 15, 2006 11:04 PM  

Post a Comment

Links to this post:

Create a Link

<< Home