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

Post Reply
User avatar
hiimcody1
Staff
Staff
Posts: 1593
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Wed Dec 28, 2011 4:59 pm

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

Post by 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
Post Reply