I found it annoying that it is possible to ignore tables when exporting with mysqldump, but not entire databases. The ability to ignore databases during an export is only helpful when you are exporting multiple (or all) databases from your MySQL server (duh). So I’ve taken the work out of doing the research for you. Here is how it works.
One of the problems that comes along with a rapidly growing homebrew obsession is that you amass a large amount of stuff. Yes, it’s a hobby that requires a lot of stuff… or at least that’s what we tell ourselves so we can buy more toys. Carbouys, pots, buckets, flasks, grains, malts, caps, a
boat-load lot of bottles, a propane tank, and a turkey fryer are just a few of the things I’ve purchased in my short time as a brewer. And yes, I meant turkey fryer (used to boil large amounts of water for 5 gallon batches of brew). I imagine I’m not the first homebrewer to put a strain on a relationship due to kitchen takeover; all this stuff was in desperate need of some organization. Since I rent, and don’t have the luxury of taking over an entire garage (yet), a more economical means of organization was required. This is how the BrewCart was born.
How To: Connect to Amazon Web Services RDS with a MySQL GUI (Sequel Pro, Navicat) using SSH Tunneling
If the title wasn’t enough, this is a quick tutorial that will show you how to use a MySQL GUI such as Sequel Pro or Navicat for MySQL to connect to a MySQL database hosted on Amazon Web Services RDS. This method is called SSH tunneling. Essentially, requests to your database on RDS will be tunneled through your SSH connection to an EC2 instance (which has the necessary firewall exemptions set up). This will allow you to connect through a trusted gateway without having all your devices authorized to connect to the RDS instance itself.
Nobody noticed, but this blog has been down for… wow… about 7 months now. That’s pretty pathetic but I’m happy to say that (obviously) I’ve finally found the time and motivation to get it back online. I’m inspired to breath life back into this blog over the next few months and hopefully it will become a habit. It’s kind of like a New Year’s resolution kind of thing.
Anybody who’s ever used PHP’s SimpleXML functions knows that it is a love/hate experience… personally, it’s usually more just hate, especially if the XML you’re consuming is relatively basic. If you’re not working with custom namespaces or anything like that, it is probably more desirable to have a simple associative array of your data. Another useful feature of having the data as an array is that arrays are session-friendly, whereas PHP sessions can’t handle SimpleXML objects. I’ve found this to be a very difficult problem to solve with Google results, as there are many different approaches. So here I am, throwing another approach into the mix.
Update 12-4-11: It’s been a while since I used this but if I remember correctly it didn’t work completely as expected. Make sure you test thoroughly before using.