Having the same problem with the lrcat catalog.
I've tried: sqlite> echo .dump | sqlite3 dbase.lrcat > TempLRCatName.sql and nothing happens, only ...>
How could I email it to you to have a try?
It was a space in front of the "echo" command
After converting the lrcat into sql , I tried to convert it back to lrcat, but after two errors
Error: near line 7895330: PRIMARY KEY must be unique
Error: near line 7895580: PRIMARY KEY must be unique
it saved a zero bytes lrcat file.
So what I did was, I opened the sql file in notepad and modified the last line from
ROLLBACK; — due to errors
with the line:
And THEN do the
C:\SQLite>sqlite3 -init tempdbase.sql dbaseRecovered.lrcat