On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote: > Hi. > > I was using SQLite with PHP 5 (MacOSX) and due to some issues the php > page timedout before completing the DB update. Now I can't read the > DB via php nor via the sqlite command line tool. I keep getting DB > busy/DB locked. How do I repair the DB and remove the "lock"and > either 1) try to recover the data in the DB or 2) verify the data is > OK and begin to reuse. >
SQLite is suppose to automatically repair itself. If you are getting "locks" that stick around, it must mean that PHP is somehow holding the database open (and locked) after it times out. Try shutting down and restarting your webserver and see if that doesn't clear the problem. -- D. Richard Hipp <[EMAIL PROTECTED]>
