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

Using the example giving for backing up MySQL/MariaDB could result in an error. #1286

Open
2 of 12 tasks
core2lord opened this issue Mar 21, 2024 · 0 comments
Open
2 of 12 tasks

Comments

@core2lord
Copy link

WHAT Needs to be Documented?

Potential issue under backup example for 'MySQL/MariaDB':

If the user enters a password after the [-p] switch, upon executing the command you will still receive an additional prompt asking for the database password. Regardless of whether the correct password was entered or not, the result will be an authentication error because it appears to be parsing the original 'password' as the database name instead.

This was my experience anyhow on MariaDB 10.6.16 & Ubuntu 22.04.1

Example of the error:

mysqldump: Got error: 1044: "Access denied for user 'owncloud'@'localhost' to database 'mydbpassword'" when selecting the database

Updated 'MySQL/MariaDB' example:

sudo mysqldump \
  --single-transaction \
  -h [server] \
  -u [username] \
  -p \
  [db_name] > owncloud-dbbackup_`date +"%Y%m%d"`.bak
sudo mysqldump \
  --single-transaction \
  -h localhost \
  -u username \
  -p \
  owncloud > owncloud-dbbackup_`date +"%Y%m%d"`.bak

WHERE Does This Need To Be Documented (Link)?

https://doc.owncloud.com/server/next/admin_manual/maintenance/backup_and_restore/backup.html

Category 'MySQL/MariaDB'

WHY Should This Change Be Made?

Preventing an error that could confuse the user executing the task.

(Optional) What Type Of Content Change Is This?

  • New Content Addition
  • Old Content Deprecation
  • Existing Content Simplification
  • Bug Fix to Existing Content

(Optional) Which Manual Does This Relate To?

  • Admin Manual
  • Developer Manual
  • User Manual
  • Android
  • iOS
  • Branded Clients
  • Desktop Client
  • Other
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