mysqldump fails from command line with provided command
Nobody has claimed this yet.
- Dominant language
- HTML
- Stars
- 273
- Forks
- 391
- Avg merge
- 1m
- Merged PRs (30d)
- 1
Description
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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Update pages/web/hosting/sql_database_export/guide.fr-fr.md. Start by reviewing the existing mysqldump command and the reported PROCESS privilege error on MySQL 5.5. Done means the guide includes the --no-tablespaces option so the documented command avoids that error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 55/100