Re: [sqlite] "restore" doesn't work

2010-04-30 Thread Alexey Pechnikov
Thanks, it's best solution! There are a lot of situations when are useful databases with different page sizes. 2010/4/30 Black, Michael (IS) : > Add a debug statement to show the page sizes being used here so you know what > to set the default size to. > >  /* Catch the case where the destination

Re: [sqlite] "restore" doesn't work

2010-04-30 Thread Black, Michael (IS)
exey Pechnikov Sent: Fri 4/30/2010 9:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] "restore" doesn't work The problem is really produced by the different page_size. I did have bugreport from my client and it's not easy to reproduce the problem by thi

Re: [sqlite] "restore" doesn't work

2010-04-30 Thread Alexey Pechnikov
The problem is really produced by the different page_size. I did have bugreport from my client and it's not easy to reproduce the problem by this error message... 2010/4/30 Black, Michael (IS) : > Also..was your database created on the same machine you're restoring on?   > Page size difference wil

Re: [sqlite] "restore" doesn't work

2010-04-30 Thread Black, Michael (IS)
nikov Sent: Fri 4/30/2010 7:44 AM To: sqlite-users@sqlite.org Subject: [sqlite] "restore" doesn't work $ sqlite3 :memory: SQLite version 3.6.23 sqlite> .restore './work.db' Error: attempt to write a readonly database sqlite> .q $ sqlite3 SQLite version 3.6.2

Re: [sqlite] "restore" doesn't work

2010-04-30 Thread Black, Michael (IS)
___ From: sqlite-users-boun...@sqlite.org on behalf of Alexey Pechnikov Sent: Fri 4/30/2010 7:44 AM To: sqlite-users@sqlite.org Subject: [sqlite] "restore" doesn't work $ sqlite3 :memory: SQLite version 3.6.23 sqlite> .restore './work.db' Error: attempt to write a rea

[sqlite] "restore" doesn't work

2010-04-30 Thread Alexey Pechnikov
$ sqlite3 :memory: SQLite version 3.6.23 sqlite> .restore './work.db' Error: attempt to write a readonly database sqlite> .q $ sqlite3 SQLite version 3.6.23 sqlite> .restore './work.db' Error: attempt to write a readonly database sqlite> .q $ sqlite3 test.db SQLite version 3.6.23 sqlite> .restore