Received this error when trying to dump a database:

[html]
mysqldump: Got error: 1449: The user specified as a definer (‘root’@’localhost’) does not exist when using LOCK TABLES
[/html]

To dump out the database run the following:

[html]
mysqldump –single-transaction -u username -p db > db.sql
[/html]

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@matthewc424.sg-host.com.