Reset git bare repo

After playing around with GIT, it is time to get serious. My intent is to revert my bare repo to the state its was before i started playing around with it. I kinda like git, but this thing has a million (actually a few dozens) set of commands some of them make sense others not really.
http://schacon.github.com/git/git.html

How do i reset my bare repo to its original state?

First check the log so you can grab the SHA1 of the original commit

git log

Note that you cannot do a “git reset sde4545e4” on a bare repo you will like get this error:
“fatal: mixed reset is not allowed in a bare repository”.

Second run the following command

git update-ref HEAD sde4545e4

Now there are still left over objects on the system. If you check the ./git/objects folder, you will see a whole bunch of directories there. You will need to get rid of them.

Third get rid of unwanted objects

git gc
git prune

Fatal error: Call to a member function execute() on a non-object in

“Fatal error: Call to a member function execute() on a non-object in”

I am not going to delve too much in trying to fix this since the solution was pretty straightforward in my case.

"MYSQL tables and Aliases are case sensitive in Most Linux Platforms"

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

So if you develop in Microsoft Windows and Upload to a linux server, you will most likely run into this issue if you do not pay attention to case sensitivity.

This case sensitivity issues with mysql on a linux/unix platform can be turned on and off in my.ini.

lower_case_table_names=1 or lower_case_table_names=0

MYSQL Unixtime to US Date Format

MySQL Unixtime to US Date Format
You can format your Unix formatted date straight from the MySQL database and here is the query that will allow you to do so:

select FROM_UNIXTIME(U.signup_date, '%m/%d/%Y %h:%i:%s') as time  from YCSOFTWARE_TBL

Server refused our key UBUNTU Solution

Server refused our key UBUNTU

After spending the last two hours working on this issue, I though it would be a good idea to post a solution.

Most online tutorials only refer to ssh_config instead of sshd_config.
Ubuntu SSH has two config files: ssh_config and sshd_config
#cd /etc/ssh/ reveals the following:

SOLUTION

I was making my changes to ssh_config but the active config file is sshd_config.

Do not forget to reload ssh after changing the sshd_config file.

sudo service reload ssh

If it is still not working :

Move your key to a different location.

Now why in the blue world do we have two SSH config files in UBUNTU.
Any idea?

Useful references
http://www.howtoforge.com/ssh_key_based_logins_putty
http://adamwright.wordpress.com/2011/05/16/ssh-error-server-refused-our-key-and-how-to-fix-it/