duganets
duganets

Reputation: 1893

How to get binary dump of SQLite memory db

If i have code like this

$dbSL = Zend_Db::factory('pdo_sqlite', array('dbname'=>':memory:'));

$dbSL->query('CREATE TABLE ...');
$dbSL->query('CREATE TABLE ...');

...

After that i whant take binary dump of this SQLite db

Thx in advice!

Upvotes: 2

Views: 1963

Answers (1)

Mark Rushakoff
Mark Rushakoff

Reputation: 258378

Take a look at this thread on Nabble. You can use the ATTACH command to save a :memory: DB to disk, but if you're only working in memory to gain speed, they make a few suggestions about reducing error checking to gain speed as well.

Upvotes: 6

Related Questions