Thursday, April 20, 2006

So, I just spent about an hour trying to get mysql working on OS X 10.4.6.

I downloaded mysql vers 5.0.19 , after about an hour of trying to set the root password, using

./mysqladmin -u root password newpassword

I got errors like
Access denied for user 'root'@'localhost' (using password: NO)

I removed the reciepts file, removed mysql, using rm -rf mysql

installed version 4, and it worked. why does software installation have to be so difficult?

(starting up mysql with mysql -u root -p )
I found mysql can start up just fine as mysql, its just that you can't create databases, etc.

Saturday, April 01, 2006

Compression for Video Ipods

The standard way of compressing for iPods (the movie to iPod option) creates files about 700K, which is good if you want to hook your iPod up to the TV, but the filesize is way too large if you're just going to view the video on your iPod. Filesize needs to be only around 400K and you'll get phenomonal results with the new H.264 codec.

So, the following shows how to compress a video at a smaller size, but looks just as good on the video iPod. plus, it'll download faster.

Open up your video in Quicktime Pro, and go to File->Export.

You want to use the MPEG-4 video setting instead of the export for iPod setting.
Choose the highlighted option:

Then change the settings to MP4, with video format of H.264, image size 320x240 QVGA, frame rate 15 or 29.97. And the biggie, the video filesize needs only to be around 300-400K to get great results. Here in this pic, I chose 320Kbps (which has nothing to do with the 320x240 frame size.

And then click on the video options dialogue box and have main and baseline options clicked. Also, encode in the best quality. There's no reason really why not too unless you've got a slow machine.

Next Are the Audio Settings:

You'll want AAC-LC (Music) setting, data rate between 64 and 192Kbps

This method works with OS X and quicktime 7.0.4 or above, so use the software updater if you need to, below 7.0.4 you'll see just the movie to iPod option.