Month: May 2010

Free image hosting

I was on the usual administrative spree that gets to every “sane” IT fella every once in a while..

In the process i was checking the analytics and traffic for one of the projects i undertook ,for the sake of learning some more advanced concepts of php and file handling in an unsafe e.g Internet, environment.

I was very pleased to see lots of people using ,in a great range of websites from blogs and forums to myspace and facebook, an quite old project i made back in 2003, namely http://imagehost4free.telmako.com

Getting recommended as an image hosting service, from one the most notorious writers in http://e-pcmag.gr/forum/6036 (one of the best Greek personal computer related forums), is just to great an honour.

It seems that free image hosting is never getting old and what’s better than a hassle free, simple upload your photo and get ready html – BB code to use in facebook, myspace, forums?

To be  honest i had almost forgot about that project but its getting a refurbish quite soon with some nice upgrades to size limitations etc..

Thanks for the vote peeps.

See you soon.

Mysql Backup – The simple script

There is only ONE  “Golden Rule of IT” : BACK IT UP OR LOOSE IT..

1)There is no such thing as security, be it firewalls, hard drives that spin in the speed of light and have 324 years guarantee or even a pact with western digital’s CEO…When it comes to crucial data stored in databases the only thing you can rely on is a : BACKUP.

2)Testing that the precious backup, you are hiding away in the swiss vault somewhere, is ACTUALLY working will prove beneficial in the long run.

And thats it.

Here is a really simple script that works in virtually every linux distro have come across and produces nice gziped backups of MySql databases.

Enjoy!

################################################################
#!/bin/bash
#18/12/2003
#Simple script to backup a specific database
#Backup script by datetime
#USE AT YOUR OWN RISK
### MySQL Server Login Info ###

DB=”Important_DB_Name_Here”

MUSER=”root”
MPASS=’mypasswd’
MHOST=”localhost”
MYSQL=”$(which mysql)”
MYSQLDUMP=”$(which mysqldump)”
BAK=”/mysqlbackups”
GZIP=”$(which gzip)”
NOW=$(date +”%d-%m-%Y”)

[ ! -d $BAK ] && mkdir -p $BAK

##ACTUAL WORK TAKES PLACE HERE##
FILE=$BAK/Desired_static_namepart-$NOW.gz
$MYSQLDUMP -u $MUSER -h $MHOST –password=$MPASS $DB1 | $GZIP -9 > $FILE

#########################################################################
# Uncomment the following line to delete files older than 10 days in the backup directory
#find  /mysqlbackups/* -mtime +10 -exec rm -f {} \;

#########################################################################