How to get a binary dump of SQLite memory db

If I have some code like this

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

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



After that, I want to take a binary dump of this SQLite db

thanks for the advice!


source to share

1 answer

Check out this thread on Nabble . You can use the ATTACH command to save the DB :memory:

to disk, but if you are only working in memory to get speed, they do some tips on reducing errors to get speed as well.



All Articles