> ... but I would like to do a 'dump' to get the SQL > > ... so I've tried a few 'system' commands A system call along the lines of `"echo .dump | sqlite3 thedb > outfile.sql"` ought to do the trick, assuming a unixy OS. Edit: escaped pipe symbol.
> ... but I would like to do a 'dump' to get the SQL > > ... so I've tried a few 'system' commands A system call along the lines of `"echo .dump | sqlite3 thedb > outfile.sql"` ought to do the trick, assuming a unixy OS. Edit: escaped pipe symbol.