Mysqldump error in VPS

Try something like this and throw it in a gz if desired.

/usr/bin/mysqldump --opt -Q user | gzip > /home/destination/filename.gz

 

This problem it's because database it's very large on tables, and --lock can't open files that it needs.

try mysqldump without --lock-tables

Code:

mysqldump --lock-tables=false --add-drop-table --add-locks --create-options --disable-keys --extended-insert  --quick --set-charset [database] > [database].sql