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

Reply via email to