Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

External DB import failure #2483

Open
emeraldium opened this issue Jul 16, 2020 · 1 comment
Open

External DB import failure #2483

emeraldium opened this issue Jul 16, 2020 · 1 comment

Comments

@emeraldium
Copy link

hello all

we are trying to migrate our gitbucket from local H2 to mysql 8.0.20.0
after creating a new empty mysql database and booting up gitbucket admin web console when i am trying to import the .sql backup file i keep getting the following error:
"java.sql.SQLSyntaxErrorException: (conn=17) Query was empty"

when trying to import the .sql backup file mnualy i get this error:
"mysql: Unknown OS character set 'cp862'.
mysql: Switching to the default character set 'utf8mb4'.
ERROR 1146 (42S02) at line 1: Table 'gitbucket.watch' doesn't exist"

anyone can assist with this?

many thanks
E

@CarlosMassiah
Copy link

I'm getting the same issue.
I install fresh gitbucket with mySQL on Ubuntu 20.04, create a test repo, export gitbucket and try to import. Then I get the
"java.sql.SQLSyntaxErrorException: (conn=17) Query was empty" error.

Setup is as described in these:
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04
https://github.com/gitbucket/gitbucket/wiki/External-database-configuration

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants