sqlite> .open test.restorednew.db
> sqlite> SELECT path,hex(path) FROM "test-directories" WHERE id=68;
> Jap�n (2002)|4A6170C3B36E20283230303229
>
>
> Regards
>
> Simon
>
>
> -Original Message-
> From: sqlite-users-boun...@mailinglists.sqlite.org
-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf
Sent: 13 July 2016 22:34
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts
records with extended characters
inal.db
> sqlite3_v3.13.0 -init newdump2.sql test.restorednew2.db
>
>
> Simon
>
> -Original Message-----
> From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-
> boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch
> Sent: 13 July 2016
sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts
records with extended characters
S.Ajina wrote:
> Can confirm that sqlite3.exe version 3.8.6 works ok restoring database
> from a .dump dump.sql file using these commands
>
> ech
On 7/13/16, S.Ajina wrote:
>> To fix this, use the same mechanism for both output and input:
>>
>> sqlite3 old.db .dump > dump.sql
>> sqlite3 new.db < dump.sql
>
> Yes this has worked. We use the method of dumping and recreating to overcome
> some database corruptions -
2.sql && echo .dump) | sqlite3_v3.13.0 test.original.db
sqlite3_v3.13.0 -init newdump2.sql test.restorednew2.db
Simon
-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
Ladisch
Sent: 13 July
On Jul 13, 2016 11:14 AM, "Simon Slavin" wrote:
>
>
> On 13 Jul 2016, at 5:22pm, Scott Robison wrote:
>
> > His program is not involved. Just the SQLite shell.
>
> He's feeding the shell with a pre-prepared file. Depending on how the OS
command
On 13 Jul 2016, at 6:26pm, Clemens Ladisch wrote:
> To fix this, use the same mechanism for both output and input:
>
> sqlite3 old.db .dump > dump.sql
> sqlite3 new.db < dump.sql
>
> or
>
> (echo .output dump.sql && echo .dump) | sqlite3 old.db
> sqlite3 -init
S.Ajina wrote:
> Can confirm that sqlite3.exe version 3.8.6 works ok restoring database from a
> .dump dump.sql file using these commands
>
> echo .dump | sqlite3_v3.8.6 test.original.db > dump_v3.8.6.sql
> sqlite3_v3.8.6 -init dump_v3.8.6.sqltest.restored.v3.8.6.db
>
> Doing the
On 13 Jul 2016, at 5:54pm, S.Ajina wrote:
> SQLite version 3.13.0 2016-05-18 10:57:30
> Jap�n (2002)|4A6170C3B36E20283230303229
> 4A 61 70 C3 B3 6E 20283230303229
> SQLite version 3.8.6 2014-08-15 11:46:33
> Japón (2002)|4A6170C3B36E20283230303229
> 4A 61 70 C3 B3 6E
On 13 Jul 2016, at 5:22pm, Scott Robison wrote:
> His program is not involved. Just the SQLite shell.
He's feeding the shell with a pre-prepared file. Depending on how the OS
command shell works, the result may depend on the text encoding used for the
contents of
-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin
Sent: 13 July 2016 16:55
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file cor
On Jul 13, 2016 9:55 AM, "Simon Slavin" wrote:
>
>
> On 13 Jul 2016, at 4:09pm, S.Ajina wrote:
>
> > Doing the same with the current version of sqlite3.exe (version 3.13.0)
corrupts the database records when there are extended characters
>
> I would
On 13 Jul 2016, at 4:09pm, S.Ajina wrote:
> Doing the same with the current version of sqlite3.exe (version 3.13.0)
> corrupts the database records when there are extended characters
I would guess that your program is handing extended characters to SQLite
incorrectly.
On windows platform, the following commands using windows command line prompt
and sqlite3.exe worked with old versions of sqlite3.exe
Can confirm that sqlite3.exe version 3.8.6 works ok restoring database from a
.dump dump.sql file using these commands
echo .dump | sqlite3_v3.8.6
15 matches
Mail list logo