Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysqldump fails from command line with provided command #1484

Open
GuimLe opened this issue May 12, 2021 · 0 comments
Open

mysqldump fails from command line with provided command #1484

GuimLe opened this issue May 12, 2021 · 0 comments

Comments

@GuimLe
Copy link

GuimLe commented May 12, 2021

On this guide, when you execute the following command on a 5.5 MySQL :

mysqldump --host=adresse_du_serveur --user=nom_utilisateur --password=mot_de_passe_utilisateur nom_base_de_données > nom_fichier_sauvegarde.sql

the dump succeed but showing the following error :

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

To prevent this error, add the option --no-tablespaces to the command, like this :

mysqldump --host=adresse_du_serveur --user=nom_utilisateur --password=mot_de_passe_utilisateur --no-tablespaces nom_base_de_données > nom_fichier_sauvegarde.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant