Received this error when trying to dump a database:

mysqldump: Got error: 1449: The user specified as a definer ('root'@'localhost') does not exist when using LOCK TABLES

To dump out the database run the following:

mysqldump --single-transaction -u username -p db > db.sql

That’s it!

 

 

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@linuxtutorial.co.uk.