diff options
| author | Valery Sizov <vsv2711@gmail.com> | 2015-06-03 14:08:30 +0300 |
|---|---|---|
| committer | Valery Sizov <vsv2711@gmail.com> | 2015-06-03 14:15:24 +0300 |
| commit | ef47607e21e5d6edc821c49e29d6259dfc08319f (patch) | |
| tree | c5f20f58cd4b16fecd7e4bae4aeb815e361b2944 /doc | |
| parent | 47f00afb8b7de642c4a19a4b291e540b93eb441c (diff) | |
| download | gitlab-ci-ef47607e21e5d6edc821c49e29d6259dfc08319f.tar.gz | |
fix backup for MySQL
Diffstat (limited to 'doc')
| -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'; +``` + |