Alex Gomes >> Blog

Wow. Time flies so fast. Another two months and its going to be summer. I always like summer. A time to rethink and attempt bold new projects.

So whats up for Summer 2007?

I will be involved with two possibly three projects this summer. I have been pusihing these projects far too long. These will be open to public, for free (possibly).

1) PPC manager: A better automated PPC manager, with advanced click fraud detection and conversion tracker.

2) Sales Projector: What if you could take historical sales data and project future sales? I know, tools like these already exist. But the twist is; project sales by data mining the Internet. Now that would be fun.

3) Still figuring it out in my head.

If you would like to propose suggestion or contribute let me know.

Alex’s MySQL Backup

AMB is a script I wrote to backup all the mysql databases in my server. I will make the script more complex in the future.

Download

Howto

Download the script
Login as root and upload it to your server
Modify the variables in the script
Chmod the script to 775
Chmod your backup directory to 777
run ./amb.sh
add to your cron for nightly dump

Features v 1.0

• Backs up database nighlty (if you run it by cron)
• Keeps an archive of database for seven days
• Compressed Sql file saves you disk space