-
Notifications
You must be signed in to change notification settings - Fork 33
Open
Description
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
Metadata
Metadata
Assignees
Labels
No labels