Skip to content

Instantly share code, notes, and snippets.

@seLain
Created November 14, 2017 09:09
Show Gist options
  • Save seLain/2d6c234b93e3d4a8398f15a3a89327f2 to your computer and use it in GitHub Desktop.
Save seLain/2d6c234b93e3d4a8398f15a3a89327f2 to your computer and use it in GitHub Desktop.
manual openproject mysql db backup
# applied when back up through 'sudo openproject run backup' not working due to access denied 1045 issue
# using mysqldump instead. be sure to replace 'BACKUP_PATH/backup.sql' with desired baclup file location.
sudo mysqldump --single-transaction --add-drop-table --add-locks --result-file=BACKUP_PATH/backup.sql --host=localhost --user=openproject --password openproject
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment