mysql incremental backup

backup.sh

#!/bin/bash

function slice() {
  lower=$1
  upper=$(expr $lower + 100000)                    
  echo "Backing up $lower"                         
  mysqldump db_name table_name --opt --no-create-info --where "id > $lower and id <= $upper" | gzip -c | ssh user@host "cat > /home/backup/dump$lower.gz"
}

lower=0
while [ 1 ] ; do                                   
  if [ $lower -ge 60000000 ] ; then                
    echo done
    exit 0
  fi
  lower=$(expr $lower + 100000)
  slice $lower
done