Changing the table prefix in an installed Wordpress. Otherwise an obvious task, but steps four and five can stump you.
For step five, the following SQL snippet may come in handy.
UPDATE new_prefix_usermeta SET meta_key = REPLACE(meta_key, "wp_", "new_prefix_");
There’s also a plugin available.
If you serve only specific file types (eg. images) it can’t hurt to secure your Wordpress uploads directory a .htaccess file. Add to the file extensions as necessary.
Order Allow,Deny
Deny from all
<Files ~ "\.(jpeg|jpg|png|gif|pdf|gz|zip)$">
Allow from all
</Files>
Movies I want to see (or see again), from Wired’s favorite sci-fi flicks (pre and post Star Wars).
And from the comments: Enemy Mine (1985) and Tron (1982).
Some movies I’d have added: West World, Barbarella, Battlestar Galactica, Back to the Future, The Last Starfighter, Total Recall, Strange Days, Dark City, Star Trek: The Undiscovered Country (the best Trek movie by far), Fifth Element, Minority Report, Serenity.
9pm Records is putting out a re-issue of Geoff Berner’s first album We Shall Not Flag or Fail, We Shall Go On To The End.
Says Berner: “The whole concept of ‘Flag or Fail’ was to make a full, eclectic singer/songwriter album with no bloody guitars on it whatsoever, and to use accordion in place of where the guitar might go. It was a risky experiment, but it worked. Its release signaled the beginning of the period in my life when I’ve earned my living through music alone. This period continues. Knock wood, and thank you for supporting what I’ve been doing.”
Whoah! 9pm has also released Aavikko, Cleaning Women, and Giant Robot.
