Re: sqlite
| From: | andu | Date: | Sun, 24 Aug 2003 03:05:10 +0000 |
| Subject: | Re: sqlite | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-160561@lists.php.net to get a copy of this message | ||
On Sun, 24 Aug 2003 13:09:55 +1000
Kevin Waterson <kevin@oceania.net> 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