Re: [pysqlite] Can you restore/import from a .sql file?

Roger Binns <[email protected]> Fri, 20 Feb 2009 10:32:49 -0800

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Al Schmeer wrote:
> I've successfully dumped a small database to a .sql file, using iterdump.
> Is there a way to restore and/or import from the .sql file?  I cannot seem
> to find a means to do this.

Use cursor.executescript passing in the entire .sql file contents.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkme90wACgkQmOOfHg372QS37ACcD6ZroSIvxqJ8sT0aBiu626Fl
xEwAoJa56peFvCa5rRZHNF+wf1y6cLUR
=LGZp
-----END PGP SIGNATURE-----