Backing MySQL Up

<1 min read

I've seen quite some talk about various Automatic MySQL Backup scripts. Maybe I'm missing the point, but backing up MySQL databases is not rocket science. I use a very simple logrotate script:

/etc/logrotate.d /mysql-backup
/opt/backups/mysql-backup.sql {
  notifempty
  daily
  nocreate
  rotate 15
  missingok
  compress
  postrotate
  # just if mysqld is really running
  if test -n "`ps acx|grep mysqld`"; then
    /usr/bin/mysqldump --user=USER --password=PASSWORD --add-drop-table --add-locks --all --extended-insert --quick -A > /opt/backups/mysql-backup.sql
  fi
  endscript
}
Logrotate provides all kinds of configuration options. There's really no need to reinvent the wheel.

dzone: Doing what's best for you

<1 min read

Rick just blogged about the user-centric philosophy behind dzone:

We've had one of those "moment of truth" experiences this past weekend, coming to understand that the only way to make our new service really, truly great is to focus relentlessly on delivering the best possible experience to our users. There is no easier, softer way.

Read more in Doing what's best for you, not us…

Paris

<1 min read

My cousin took some totally awesome pictures of Paris.

dzone

<1 min read
Been there yet?