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

[hiimcody1]

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 their usage in a shared environment.

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