Re: [sqlite] Sqlite Secure backup

David Costa <[EMAIL PROTECTED]> 03/06/2004 09:26 AM To: [EMAIL PROTECTED] cc: Subject: [sqlite] Sqlite Secure backup > I am in the process of writing a PEAR package to handle Sqlite backups > (both local backups and remote backups) and I am

Re: [sqlite] Sqlite Secure backup

On Jun 3, 2004, at 2:17 AM, Darren Duncan wrote: At 2:04 AM +0200 6/3/04, David Costa wrote: so in this case you just check if a file .journal exist and if it does you keep that file right ? Yes. But check the sqlite.org website documentation to make sure that is the correct file name. from here

Re: [sqlite] Sqlite Secure backup

David, please send all replies, like the original questions, to the list ([EMAIL PROTECTED]), not directly to me. You would get a quicker response that way, and I don't feel soley responsible for answering. At 2:49 AM +0200 6/3/04, David Costa wrote: On Jun 3, 2004, at 2:17 AM, Darren Duncan w

Re: [sqlite] Sqlite Secure backup

At 2:04 AM +0200 6/3/04, David Costa wrote: so in this case you just check if a file .journal exist and if it does you keep that file right ? Yes. But check the sqlite.org website documentation to make sure that is the correct file name. It would be interesting to see how you did it in Perl The

RE: [sqlite] Sqlite Secure backup

At 9:42 AM +1000 6/3/04, Greg Obleshchuk wrote: Hi David, I have been thinking about developing a backup/restore as part of my wrapper. It would be great to have all of these features compatible. I really wanted to backup the database and then have the ability to restore just one table or the enti

Re: [sqlite] Sqlite Secure backup

On Jun 3, 2004, at 1:52 AM, Darren Duncan wrote: At 1:43 AM +0200 6/3/04, David Costa wrote: thanks for your reply, few more questions 1. Obtain a file system read lock on the SQLite database file. this shouldn't be a problem but I will need to do it from php. How would you do it in console ? You

Re: [sqlite] Sqlite Secure backup

At 1:43 AM +0200 6/3/04, David Costa wrote: thanks for your reply, few more questions 1. Obtain a file system read lock on the SQLite database file. this shouldn't be a problem but I will need to do it from php. How would you do it in console ? You are asking a PHP-specific question. Look at the

Re: [sqlite] Sqlite Secure backup

facility but I could also work on the restore one, alas only in PHP. Cheers David Costa Greg -Original Message- From: David Costa [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 June 2004 9:26 AM To: [EMAIL PROTECTED] Subject: [sqlite] Sqlite Secure backup Hello Everyone, I am a contributor on

Re: [sqlite] Sqlite Secure backup

On Jun 3, 2004, at 1:38 AM, Darren Duncan wrote: At 1:26 AM +0200 6/3/04, David Costa wrote: I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some suggestions. Is the right way to proceed the db dump ? I assume t

RE: [sqlite] Sqlite Secure backup

create a wiki page on sqlite.org? Greg -Original Message- From: David Costa [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 June 2004 9:26 AM To: [EMAIL PROTECTED] Subject: [sqlite] Sqlite Secure backup Hello Everyone, I am a contributor on the php project ( my profile is available at http

Re: [sqlite] Sqlite Secure backup

At 1:26 AM +0200 6/3/04, David Costa wrote: I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some suggestions. Is the right way to proceed the db dump ? I assume that copying the db will result in a corrupted fi

[sqlite] Sqlite Secure backup

Hello Everyone, I am a contributor on the php project ( my profile is available at http://pear.php.net/user/gurugeek ) where I maintain several extensions. I am in the process of writing a PEAR package to handle Sqlite backups (both local backups and remote backups) and I am looking for some