Try the --lock-all-tables or --lock-tables options to mysqldump. More is at http://dev.mysql.com/doc/mysql/en/mysqldump.html. Dave > Does anyone know offhand how to lock a mysql database for backup? I'd like > to cron a table dump, but I would like to lock the database before doing > so. > Any ideas?