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

数据库的表不全 #80

Open
weidongbcn opened this issue Dec 9, 2019 · 8 comments
Open

数据库的表不全 #80

weidongbcn opened this issue Dec 9, 2019 · 8 comments

Comments

@weidongbcn
Copy link

我导入到mysql, 运行的时出现
[ ORM][ ERROR]:Error 1146: Table 'go2o.registry' doesn't exist [ SQL]:SELECT registry.key,registry.value,registry.default_value,registry.options,registry.flag,registry.description FROM registry [Args]:[[]]

ixre added a commit that referenced this issue Dec 10, 2019
@ixre
Copy link
Owner

ixre commented Dec 10, 2019

@weidongbcn 数据库需要使用postgresql 导入备份文件: go2o_pg.sql

@weidongbcn
Copy link
Author

数据库需要使用postgresql 导入备份文件: go2o_pg.sql, 这是哪个版本的postgresql?
我用pgadmin恢复,错误信息是:pg_restore: [归档] 在文件头中有不支持的版本 (1.14)

@ixre
Copy link
Owner

ixre commented Dec 13, 2019

@weidongbcn 1.14 是pgadmin的版本, 我这用的是最新的pgadmin

@zhuewizz
Copy link

zhuewizz commented Mar 10, 2020

我直接用:pg_restore: [archiver] unsupported version (1.14) in file header
cmd:pg_restore -h localhost -p 5432 -U postgres -W -d go2o -v Downloads/go2o-master/docs/data/go2o_pg.sql
https://blog.csdn.net/qq_31388481/article/details/98039882
应该是版本问题,为什么不提供sql文件格式

@weidongbcn
Copy link
Author

我最后没有解决,放弃了。我也不懂库主什么意思,出于什么考虑而不提供正确的sql文件。

@zhuewizz
Copy link

我最后没有解决,放弃了。我也不懂库主什么意思,出于什么考虑而不提供正确的sql文件。

我的意思是直接导出SQL文件,我们用SQL文件导入就好了:如 \ir xxx.sql

@weidongbcn
Copy link
Author

在linux 的console 中用上面的命令恢复成功。

@ixre
Copy link
Owner

ixre commented Apr 28, 2020

@zhuewizz 用命令可以导入的, 或者用pgadmin导入下

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

No branches or pull requests

3 participants