I accidentally dropped my entire blog sql (just meant to drop one table) about 5 mins ago and had to restore from last nights backup. Go me =(
trying to do like 900000 things before leaving for san jose ses…. sorry for comments lost on the whole drug dealing post =(
About the author...
Jeremy Schoemaker – who has written 2415 posts on ShoeMoney.com.
Hi I am Jeremy Schoemaker and ShoeMoney.com is my blog. 99% of the post here are done by me but you will see others occasionally make guest posts. This blog is fun to write but for my day job I run several online companies.
Images provided by ShutterStock
Using Delicious to Understand Your Users 
How I made 15,000.00 In 1 Month Just By Tweeting 
Don’t Obsess About Design For Design’s Sake 
{ 33 comments… read them below or add one }
i know u tried to defend it later with your respect for indians and seo meet thingy, but for a moment there u went racist.for sure. stupid ass neighbours cud be anyone so why “highlighting” the indian bit? bad flavour.tsk.
yea thats what it is i’m racist you fucking moron.
hmm nice job genbucks fast track to the shoemoney shitlist
One of the few times I leave a comment too….grrrr
First, pavs wtf? there wasnt a single racist comment in that post. And insulting the dude with the microphone or blog is not a smart idea.
Second,can it really be racism if Indian is a nationality and not a race?
Wow, that is insane. I have never done that before. Luckily you had a backup.
actually not luck
. Its hard to shoot from the hip without a good backup system.
At least you know how to restore your DB…I F**ked up about a week ago and….well….I rather not talk about it
Quickly, type this into a shell: DROP DATABASE Shoemoney_Blog;
lol, for a moment there i thought you didn’t like the comments and deleted them
man its happens to the best of them. Another reason to backup ofen!
It happens to the best of us. Years ago one sleep-deprived day I once accidentally deleted a whole development environment, histories included, of an entire corporate intranet. Long. Live. Backups.
We all make mistakes, Shoe =) Good on ya for backing up!
I had the same reaction. I even sent him an email with an image of his new tee shirt, Shoemoney says Stop Snitchin.
Thought I had really pissed him off.
Can you tell us more about your backup system please. Id really be interested to see a post about it and what you do. I export my databases once a week but it sounds like you have everything daily. Please share some details
You are an idiot pavs. I hate when people cry racism over nothing.
Sweet, at least you had a backup!
You should use the drugs you sell
But yay for backups, I have nightly cron running on my servers to backup my sql and site’s code… incase I make booboo’s too.
If you have shell access to your shell you should be able to create a cron job that you can set to run a script everynight
here’s a sample of the script I run every night.
#!/bin/bash
TIMESTAMP=`date +%m-%d-%y-%H%M`
cd /backups/mactap
find /backups/mactap/*.tar.gz -mtime +7 -exec rm -f {} \;
# my database
DBNAME=use_yours
mysqldump --add-drop-table --host=mactap.com -u myusername -pMyPassword $DBNAME > $DBNAME.sql
tar czpf $DBNAME.sql.$TIMESTAMP.tar.gz $DBNAME.sql
rm -f $DBNAME.sql
I hope this sheds some light on a cheap way of backing up a database
People love to drop the racism card whenever they can…
That’s not nice at all.
I hate messing with cron. I dont know if its just my host or lack of experience but I cant get cron to do anything these days.
As for shoemoney being a racist, well I have meet the man (and his wife) personally and they have come off as very warm, and I am black. Also, I have chatted with shoemoney *waaaaaay back when he used to hangout on wmr chatroom) and we would talk about things here and there and I told him about my partner in india and not once did he sau anything out of order so my money is on shoe just being a human being.
Heheh.. *waits for the ‘ihatepavs’ website*
Yikes, good think you had it backed up.
Noticed I disappeared from the top commentators section though. Accident or have I fouled up some way
Happens to everyone Shoe… at least you are diligent with your backups!
I don’t think it was racist either (following on the above comments). Sorry to hear about the blog problems!
Ahh, a classic *slaps forehead* moment. Ive done it before too :/
i think it’s oversensitivity, if you have to frame something into rascism, then it isn’t. mentioning race doesn’t make it rascist… thanks for playing the card anyway
Nice man, hopefully it never happens again.
Lemme guess… THIS is the reason your title has been messed up recently… honestly man just send me a private email or something it’s driving me nuts :S
Shoemoney’s never lucky haven’t ya hearddd?! :p
I agree though shoe – there is no such thing at luck… I lose at blackjack more times than I win because the odds are against me… I make money online because I work really hard…
good to see im not the only one who does dum things from time to time