Off late, I’ve been working on a project where we’re using a simple key-value store instead of a relational DBMS like MySQL, and I’ve come to realize that if done properly, a lot of applications don’t require a relational database. Redis, being a simple key-value store is ridiculously quick, so try it out, and avoid MySQL when its not really required.
Posts Tagged ‘mysql’
Check out Redis
Sunday, August 16th, 2009Periodically back up MySQL with a Shell Script
Saturday, April 19th, 2008There are many advantages to using the shell, one is making backups. With the following code and a cron job, periodically backing up MySQL databases is a breeze.
#!/bin/sh mkdir `date +%m-%d-%y-%Hx%M` cd `date +%m-%d-%y-%Hx%M` mysqldump -h localhost -u user -ppassword dbname > file.sql