Maybe the mysql user "moodleuser" don't have permission LOCK TABLES for 'moodle' database. It's easy to set it with phpmyadmin, privileges section.
Backup and restore
Backing up the whole site doesn't work
This discussion has been locked so you can no longer reply to it.