How To Add AWS EC2 API Tools to Ubuntu AMI Instance

Author: , March 28th, 2013

https://help.ubuntu.com/community/EC2APITools https://help.ubuntu.com/community/Repositories/CommandLine#Adding_the_Universe_and_Multiverse_Repositories As root in /root: vim /etc/apt/sources.list ## Added to the bottom: deb http://us.archive.ubuntu.com/ubuntu/ hardy multiverse deb-src http://us.archive.ubuntu.com/ubuntu/ hardy multiverse deb http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse deb-src http://us.archive.ubuntu.com/ubuntu/ hardy-updates multiverse apt-get update apt-get install sun-java5-jre apt-get install unzip wget http://s3.amazonaws.com/ec2-downloads/ec2-api-tools-1.3-34128.zip unzip ec2-api-tools-1.3-34128.zip export EC2_HOME=/root/ec2-api-tools-1.3-34128 export PATH=$PATH:$EC2_HOME/bin mkdir .pem Copy downloaded X.509 private key and cert into […]

Categories: How-To's, Technology Tags: , , , , , , , , , | No comments

How To Create a List of Reports, Queries or Tables in Microsoft Access

Author: , February 25th, 2012

This query will list the names of the reports in the database: SELECT MSysObjects.Name AS Report_Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name; This query will list the names of the queries in the database: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5)); This query will list the names of the tables in the database: SELECT MSysObjects.Name […]

Categories: How-To's, Technology Tags: , , , , , , , | No comments

How To Export WordPress From The Command Line CLI

Author: , July 29th, 2011

Create a file called export.php in the wordpress top directory containing the following (remember to add the PHP tags at the top and bottom):

Categories: Rants Tags: , , , , | 3 comments

How To Import Excel CSV Into MySQL Via phpMyAdmin

Author: , July 22nd, 2010

Categories: How-To's, Technology Tags: , , , , , , | No comments