Backing up the whole site doesn't work

Backing up the whole site doesn't work

by Edu Garcia Sacristan -
Number of replies: 1
Hi,

I've followed the instructions for backing up the whole site but I can't manage to make it work:

mysqldump -h localhost -u myuser --password=mypasswd -C -Q -e -a moodle > moodle-database.sql

and I've got this message

mysqldump: Got error: 1044: Access denied for user 'moodleuser'@'localhost' to database 'moodle' when using LOCK TABLES


any clue?

Thanx in advance
Average of ratings: -
In reply to Edu Garcia Sacristan

Re: Backing up the whole site doesn't work

by Havel Lieb -
Maybe the mysql user "moodleuser" don't have permission LOCK TABLES for 'moodle' database. It's easy to set it with phpmyadmin, privileges section.
Average of ratings: -