I'm trying to create a dump of a mysql databases stored procedures and table 'shapes' without locking any rows.
mysqldump -uread_only -p --routines -d --skip-add-locks the_db_name
This doesn't work because I don't have permission to lock the table. I shouldn't need to, as I don't want to copy the data itself. The stored procedures only change every year or so, so I would be unlucky to catch a conflict!