Re: [Bug-gnubg] sqlite sync

[Achim Mueller]

* Christian Anthon <address@hidden> [080108 12:01]:
> Achim Mueller wrote:
> > Hi folks,
> > 
> > I have a question regarding the sqlite database:
> > 
> > Is it possible to sync databases on different computers? I used a db on
> > my notebook and wanted to copy it to my pc, but though "relational test"
> > says that everything is fine, gnubg can't handle the database and
> > mumbles something from "encrypted."
> > 
> 
> It should work I guess, unless you have incompatible versions. If it is
> a one-time problem you could dump the database as text on one computer
> and import the text file on the other. If you want true synchronization
> you are probably better of using a real database server like mysql.

One step further:

1. With no existing database gnubg creates an empty file after
"relational test" but complains

(No game) relational test
Database table check failed!
The table gnubg.match is missing.
(No game)

2. When running "python database.py" or (whithin gnubg) "load python
database.py" I get no output at all.

3. When running "sqlite ace.db < gnubg.game.sql" it creates the
structure, but something seems to be missing, because I still get the
same error message after "relational test"

(No game) relational test
Database table check failed!
The table gnubg.match is missing.

So I took the windows database, renamed it and gnubg was satisfied. But
when I try a sqlite command like "sqlite ace.db ".dump" it complains
"Unable to open database "ace.db". file is encrypted or is not a 
database."

Does anyone uses linux _and_ sqlite and can send me a dump of an empty
database?

Ciao

Achim