I tried these steps but i am getting syntax error while restore the backup
1. Able to take backup of existing Gitlab
2. Exported and converted the existing MySQL database in the GitLab backup
file
3. Installed Gitlab 6.8.1 in same server using this deb file, that is
gitlab_6.8.1-omnibus.4-1_amd64.deb
4 Restart the server, and able to login into Gitlab with default username
and password in to the latest installation
5 Stopped unicorn and sidekiq services
6. Tried to restore the backup into it,But I am getting the following
syntax error
root@next-cm:/var/opt/gitlab/backups
-> sudo gitlab-rake gitlab:backup:restore BACKUP=1440578430
WARNING: Nokogiri was built against LibXML version 2.8.0, but has
dynamically loaded 2.7.8
Unpacking backup ... done
Restoring database ...
Restoring PostgreSQL database gitlabhq_production ...
psql:/var/opt/gitlab/backups/db/database.sql:22: ERROR: syntax error at or
near "`"
LINE 1: DROP TABLE IF EXISTS `broadcast_messages`;
^
psql:/var/opt/gitlab/backups/db/database.sql:36: ERROR: syntax error at or
near "`"
LINE 1: CREATE TABLE `broadcast_messages` (
^
psql:/var/opt/gitlab/backups/db/database.sql:43: ERROR: syntax error at or
near "`"
LINE 1: LOCK TABLES `broadcast_messages` WRITE;
^
psql:/var/opt/gitlab/backups/db/database.sql:46: ERROR: syntax error at or
near "UNLOCK"
LINE 1: UNLOCK TABLES;
^
psql:/var/opt/gitlab/backups/db/database.sql:52: ERROR: syntax error at or
near "`"
LINE 1: DROP TABLE IF EXISTS `deploy_keys_projects`;
^
psql:/var/opt/gitlab/backups/db/database.sql:63: ERROR: syntax error at or
near "`"
LINE 1: CREATE TABLE `deploy_keys_projects` (
^
psql:/var/opt/gitlab/backups/db/database.sql:70: ERROR: syntax error at or
near "`"
LINE 1: LOCK TABLES `deploy_keys_projects` WRITE;
^
psql:/var/opt/gitlab/backups/db/database.sql:73: ERROR: syntax error at or
near "UNLOCK"
LINE 1: UNLOCK TABLES;
^
psql:/var/opt/gitlab/backups/db/database.sql:79: ERROR: syntax error at or
near "`"
LINE 1: DROP TABLE IF EXISTS `emails`;
^
psql:/var/opt/gitlab/backups/db/database.sql:91: ERROR: syntax error at or
near "`"
LINE 1: CREATE TABLE `emails` (
^
psql:/var/opt/gitlab/backups/db/database.sql:98: ERROR: syntax error at or
near "`"
LINE 1: LOCK TABLES `emails` WRITE;
^
psql:/var/opt/gitlab/backups/db/database.sql:100: ERROR: syntax error at
or near "`"
LINE 1: INSERT INTO `emails` VALUES (1,97,'ryan.b.har...@gmail.com',...
^
psql:/var/opt/gitlab/backups/db/database.sql:102: ERROR: syntax error at
or near "UNLOCK"
LINE 1: UNLOCK TABLES;
^
psql:/var/opt/gitlab/backups/db/database.sql:108: ERROR: syntax error at
or near "`"
LINE 1: DROP TABLE IF EXISTS `events`;
^
psql:/var/opt/gitlab/backups/db/database.sql:129: ERROR: syntax error at
or near "`"
LINE 1: CREATE TABLE `events` (
^
psql:/var/opt/gitlab/backups/db/database.sql:136: ERROR: syntax error at
or near "`"
LINE 1: LOCK TABLES `events` WRITE;
^
psql:/var/opt/gitlab/backups/db/database.sql:138: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:139: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:140: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:141: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:142: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:143: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:144: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:145: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:146: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:147: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:148: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:149: invalid command \'
psql:/var/opt/gitlab/backups/db/database.sql:150: invalid command \'
--
You received this message because you are subscribed to the Google Groups
"GitLab" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to gitlabhq+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/gitlabhq/a09a5d4a-48ea-425d-b6c8-11d7572c82ec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
