October 13, 2013
I’ve spent some time putting together a solution for automated database backups (from MariaDB in this case) to a remote data storage. Since my web host only does backups for my site itself, I was left to find a solution on my own. My goal was to find something that was simple, efficient, and most importantly of all, automated.
Here’s a brief overview of what my backup solution consists of:
- A bash script is run weekly through
- This script first creates a gzipped database dump using
- The dump is then uploaded to Dropbox1 using Dropbox Uploader
- Once it’s uploaded to Dropbox, the local copy is deleted
The bash Script
mysqldump --user=username --password=password --host=hostname --databases database1 database2 | gzip >$_file
./dropbox_uploader.sh -q upload $_file "/DB Backups/$_file"
You can download a copy of this script here. Most of it should be self-explanatory. Here’s where you might want to change something:
- You can change the date format
- I have it set to upload to the DB Backups folder in the root of my Dropbox; you can set this to whatever you want
- Put your own database info in to the
Setting Dropbox Uploader Up
dropbox_uploader.sh is a
bash script that provides an interface to Dropbox. You can download it from the Github page, and follow the instructions to set it up. Place this file in the same directory as the script above unless you change the reference in the script.
I ended up giving the Uploader script full access to my Dropbox, as I wasn’t sure how to give it application-specific storage and yet still access a folder in the root of my Dropbox.
Once all of this is set up, the script will automatically upload a backup of your database to your Dropbox at whatever interval you set.
May 13, 2013
Ever since Google announced they were shutting Reader down, I’ve been looking for a new RSS reader to replace it. I have since settled on Tiny Tiny RSS, a self-hosted package with a nice, clean interface. It also has a plugin system, which lets me use the Reeder app on my iPhone by having Tiny Tiny RSS emulate the Fever API.
I’m running all of this here on Nearly Free Speech, and I thought I would document the process in case it helps anyone out, including getting Reeder to sync with TT-RSS.
Continue reading “Tiny Tiny RSS + Nearly Free Speech”
November 29, 2012
iTunes 11 was released today, and seems to have made at least one major feature change: iTunes DJ is gone, replaced by a new feature called Up Next (the small dialog box open in the screenshot above).
How it works:
- Everything has a little arrow button that lets you Play Next or Add to Up Next. This button shows up for albums, individual songs, playlists, artists, and so on.
- The Up Next dialog box is opened by clicking on that “list” icon in the right side of the player area, or by pressing Command + Option + U on the keyboard.
- There, you can see previously played tracks, delete tracks from the Up Next list, rearrange them, and so on.
When I realized that iTunes DJ had disappeared, my first thought wasn’t good. But after using the Up Next feature for a while, it has grown on me a lot. I actually think it’s a much more streamlined implementation of the feature than iTunes DJ ever was.
The only problem is that dialog box. It’s so small, and when you start queuing whole albums back to back, that’s only going to compound this limitation.
My suggestion: Make the Up Next feature a whole sidebar to the right on its own. This may cut into the screen real estate for the item listing, but it’s a lot better than exiling such a main feature to a small dialog box.
Apple definitely seems to be limited with screen real estate with iTunes 11, though.
Update: Just discovered something new. In the Mini Player (Command + Option + M) mode, opening the Next Up list makes it a windowed view. Pretty cool, check it out in the screenshot to the right.
August 10, 2012
Imagine my surprise when my system couldn’t find
svn anymore… it seems Apple left it out of OS X 10.8 for whatever reason.
Luckily, you can just download the “Command Line Tools for Mountain Lion” package from the Apple developer site.
Edit: Make sure you download the package for Mountain Lion, not just Lion. Re-downloading now…
July 3, 2012
They gave us folders in Google Reader… so why is this still such a mess?