dragonimp: (One of those days)
dragonimp ([personal profile] dragonimp) wrote2011-07-20 10:58 am
Entry tags:

the joys of Web development

I spent much of yesterday and the day before fighting with my computer. See, when I upgraded to OS 10.6, it apparently wiped out all the settings I had in place to let PHP and MySQL work. Okay, not a big deal, I just have to set things up again, right? Well, PHP wasn't a problem, it was just a matter of finding the right settings document and changing a few lines. SQL on the other hand...

First, Apple is no help. When they came out with OS 10 they made a big deal about it being developer friendly, you can get right into the code, etc. etc. Not untrue, but THEY don't tell you how to set any of it up. I don't even want to mess around with the computer's code, all I want to do is build Web pages using MySQL. The OS has the database capabilities, but it's switched off by default and they don't give you ANY help with switching it on.

Anyway, Googling turns up a number of pages with instructions and walk-throughs, and they all seem simple enough. Except that they all have something like this:
  • Download the MySQL package for Mac OS X.5 (32 or 64 bits depending on your machine)

  • Install everything in the package in this order: mysql, the startup item, the preference pane.

  • Start MySQL in the preference pane.

First off, there's at least two dozen items in the package, not three. But okay, I'll find those three and install them first. But no matter which piece I try to install, I get an error. I found another set of instructions that has you use Terminal (Unix commands), and those work up to the point where - you guessed it - I try to install the SQL package. Then I get a "unknown command" error. The SQL package has a text file with instructions to install using Terminal, but those also give me an "unknown command" error.

Clearly I'm missing something.

lynda.com has a video tutorial on setting up MySQL on a Mac, and they're usually pretty good. At least with a video, I should be able to see what it's supposed to look like and where things are supposed to go. Hopefully. I don't want to spend too much more time on this but I want things to work.

Goddamit Apple, this shouldn't be this hard.

Edit: Should've gone to lynda.com in the first place. It's working now, but it seems to have wiped out all the test databases I'd had. Great.

[identity profile] meredavey.livejournal.com 2011-07-20 08:46 pm (UTC)(link)
Ouch!

I do website design as well - (I don't use apple however, I have a dislike of Apple products...)

But anyways, I once forgot to backup all my website files and I forget what I did, but I did something & had to start my website from scratch.

What type of web development? My father also works with some sort of web development so I've learned a lot from him, don't mind me too much, I'm just kind of curious. ^_^

[identity profile] dragonimp.livejournal.com 2011-07-21 01:17 am (UTC)(link)
I generally like Mac's OS, but oy... they were really not making me happy with this -_-. Once it's set up it runs fine, but I'm getting the impression that Apple doesn't really want you to use it. I hadn't thought it would wipe out my existing databases though. For all I know the data itself could still be there, but I have no idea where it puts it! (The main ones on my Web server, anyway, so all I lost was the ones I used for testing, thankfully.)

I'm mostly a dabbler with Web design, really ^^. I like playing with layout and structure. I've started teaching myself things like PHP and MySQL, and more recently a bit of Javascript, but I still don't try to do anything too fancy. My pages are up at http://www.catjester.com/takeshelter/ if you're curious - the two big database/PHP sites are Fanworks and my Portfolio, most of the rest of it is basic HTML and CSS.

[identity profile] meredavey.livejournal.com 2011-07-21 01:54 am (UTC)(link)
Yeah, I don't do anything much serious with it either, but I still find it fun to toy with.

I've had my website since, hmm. 2006? But several different domains, I've had my most recent since 2008, so it's been 3ish years. (which means 12 * 3 ~ 36 layouts. I like photoshop a little /too/ much I should think.

But I love how you've got the navigation set up!

Thats a neat little trick!