macblaze.ca

I came across some really powerful typography-based videos the other day and thought I wanted to steal one to post on my site.

First up was to download the .flv file. Easily accomplished on a Mac by using Safari.

Open the page with the movie and press Command-Option-A, which shows the Activity window. If you’re also loading other sites, you’ll see a list of them: scroll until you find the YouTube page and click on the arrow to show details about what is being loaded.

You will certainly notice an element whose size is over 0.5MB (most of the time, over 5MB). Double-click on it (even if it is still loading), and Safari will download it. When the download is over, navigate to the file in the Finder (which will probably be called get_video) and add the extension .flv to its name.

Next up was trying to get a an flv plugin so I could easily run them on the WordPress site. I heard a lot of good things about FLV Player Plugin v2.0 but in the end I couldn’t get it to run. I have no idea why. One of things that I had to do was edit the php file to correct the location of the swfobject.js. Default expects it to be placed in the plugins directory – but the file exists in plugins/flv-player. Modify line 20 to update the correct path to swfobject.js or the “Get Flash” icon will show up.

Still it wouldn’t play the flv and I have no idea what I did wrong. While cruising the WordPress site I came across ZD YouTube FLV Player which offeered more options and actually worked for me (other than the autoplay switch which still won’t work…). Anyway here are the usage and attributes:

Usage:
[zdvideo]url[/zdvideo]

‘url’: This is the URL of either a youtube video or flv video file. Example – http://in.youtube.com/watch?v=7HdJgf3yXM0 or http://www.yourdomain.com/videos/myvideo.flv

Attributes:
width – Default is “425”. This is the width of the player including border.
height – Default is “349”. This is the height of the player including border.
align – Alignment of the Flash Player. Default is “center”. Available Options: “left”/”right”/”center”
border – Show/Hide Flash Player Border. Default “yes”. Available Options: “yes”/”no”
fullscreen – Show/Hide full screen button. Default “yes”. Available Options: “yes”/”no”
theme – Name of the theme you want to use for the Flash Player. Default “dark”.
autoplay – Set video auto play On/off. Default “no”. Available Options: “yes”/”no”

Themes:
Dark
Glossy
Gray
Simple 1
Simple 2

A pic of Jim, one of the owners of Hole’s on a transit bus advertising the City of St Albert.

Well the computer blew up. I restarted it and it wouldn’t boot up again. Couldn’t mount the harddrive via target disk mode… nothing. This led me to believe it was the harddrive.

So while I took the beastie in to get serviced (seems that the G5 iMacs with iSight are virtually impossible to open without the proper tools I figured better safe than sorry) I decided to see if I could rescue my blog. Google caches accounted for most of the posts up till May 09 and luckily I had backed up everything to the new mac mini in March. That meant potentially I was only out of action for the month of April which wasn’t bad all in all.

Here begins the trials…
Firstly the mac mini is an intel chip and I couldn’t find an install for the same version of mysql as was on the iMac. And it turns out it is virtually impossible to restore the database files across version. The preferred way is to do a database dump from the source database and a restore on the new one:
admin$ mysqldump [databasename] > [Newdatabasename.sql]
then
admin$ mysql -u[user] -p [databasename] < [Newdatabasename.sql]
This basically left me screwed until I got a call to tell me it was my logic board and not the drive that had failed. 2nd time for a logic board on that piece of hardware you may recall. One of my few Mac lemons...

So I swung by the shop, picked up the drive and a new sata case, had the poor old G5 recycled. I successfully booted the mini from the old drive and did the dump. So now comes the easy part. I tried a new install on the mini of everything (php, mysql, wordpress) but it wasn't as easy as I remembered.

I downloaded...
mysql from here:
dev.mysql.com/downloads/mysql/5.1.html
php from Marc Liyanage's site: www.entropy.ch/software/macosx/php/
and a new clean install of wordpress: codex.wordpress.org/Installing_WordPress

The problem was all my notes about granting privileges and making databases and whatnot are on this stupid blog (inaccessible at that point you see) and thus the install took longer than expected.

I had trouble starting mysql until I tried this:
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql

So then …
Login to mysql after the install: mysql -uroot (no password)
Then:
mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
-> IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> EXIT

After that you should set the root password for mysql
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password');

After restoring my files and themes I was up and running again. Now I guess its time to clean up the theme a little…