Clever Geek Handbook

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!

+2


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.



+6


source






More articles:


All Articles