diff options
| author | Valery Sizov <valery@gitlab.com> | 2015-06-03 11:20:15 +0000 |
|---|---|---|
| committer | Valery Sizov <valery@gitlab.com> | 2015-06-03 11:20:15 +0000 |
| commit | 54bd76399ddf5fb925df01d9f86ed020c475b3ba (patch) | |
| tree | c5f20f58cd4b16fecd7e4bae4aeb815e361b2944 | |
| parent | 47f00afb8b7de642c4a19a4b291e540b93eb441c (diff) | |
| parent | ef47607e21e5d6edc821c49e29d6259dfc08319f (diff) | |
| download | gitlab-ci-54bd76399ddf5fb925df01d9f86ed020c475b3ba.tar.gz | |
Merge branch 'fix_backup' into 'master'
Backup issue with MySQL
https://gitlab.com/gitlab-org/gitlab-ci/issues/159
https://dev.gitlab.org/gitlab/gitlab-ci/issues/250
See merge request !113
| -rw-r--r-- | doc/install/installation.md | 2 | ||||
| -rw-r--r-- | doc/raketasks/backup_restore.md | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/doc/install/installation.md b/doc/install/installation.md index 614fbee..ef78f2d 100644 --- a/doc/install/installation.md +++ b/doc/install/installation.md @@ -73,7 +73,7 @@ You can use either MySQL or PostgreSQL. mysql> CREATE USER 'gitlab_ci'@'localhost' IDENTIFIED BY '$password'; # Grant proper permissions to the MySQL User - mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; + mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; # Logout MYSQL mysql> exit; diff --git a/doc/raketasks/backup_restore.md b/doc/raketasks/backup_restore.md index efa95ef..5c54960 100644 --- a/doc/raketasks/backup_restore.md +++ b/doc/raketasks/backup_restore.md @@ -218,3 +218,11 @@ gitlab_ci['backup_keep_time'] = 604800 NOTE: This cron job does not [backup your omnibus-gitlab configuration](#backup-and-restore-omnibus-gitlab-configuration). +## Known issues + +If you’ve been using GitLab CI since 7.11 or before using MySQL and the official installation guide, you will probably get the following error while making a backup: `Dumping MySQL database gitlab_ci_production ... mysqldump: Got error: 1044: Access denied for user 'gitlab_ci'@'localhost' to database 'gitlab_ci_production' when using LOCK TABLES` .This can be resolved by adding a LOCK TABLES permission to the gitlab_ci MySQL user. Add this permission with: +``` +$ mysql -u root -p +mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON `gitlab_ci_production`.* TO 'gitlab_ci'@'localhost'; +``` + |