Why do I get an "Access denied" error when trying to use mysqldump?

Post Reply
User avatar
hiimcody1
Staff
Staff
Posts: 1384
Joined: Wed Dec 28, 2011 4:59 pm

Why do I get an "Access denied" error when trying to use mysqldump?

Post by hiimcody1 » Mon Apr 05, 2021 4:09 pm

You may encounter this error when trying to use mysqldump on your webhosting as mysqldump tries to export tablespaces by default. Tablespaces were introduced in MySQL 5.7, however we do not allow the usage of them due to security issues associated with them.

You can get successfully dump your databases by adding the "--no-tablespaces" parameter to your command. For example:

Code: Select all

mysqldump -p --no-tablespaces your_database > db_backup.sql

Post Reply