On Sun, 24 Aug 2003 13:09:55 +1000 Kevin Waterson <[EMAIL PROTECTED]> wrote:
> I am writing an admin for sqlite but have struck a > problem with exporting data. I wish to simply > get a dump of the current sql database. from > the commandline this would be done with .dump > however this causes an error when used with > sqlite_query() > > Is there any other method to get a sqlite dump? I just installed the sqlite extension today myself and was looking for all those dot commands but I don't think they are supported by the extension unfortunately. My suggestion is to call sqlite with exec() in order to get the .dump. $command="sqlite db_name '.dump'"; exec($command,$result); print_r( $result);// shows the dump array > > Kind regards > kevin > > -- > ______ > (_____ \ > _____) ) ____ ____ ____ ____ > | ____/ / _ ) / _ | / ___) / _ ) > | | ( (/ / ( ( | |( (___ ( (/ / > |_| \____) \_||_| \____) \____) > Kevin Waterson > Port Macquarie, Australia > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- Andu -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php