I have found my problem - it was some stupid configuration problem.
But I will still want to leave the question open - What is the best way to
create a new 'clean' copy of the database file, resetting all the
auto-increment fields?
Thanks,
Omri
On Tue, Mar 29, 2011 at 11:36, Omri
On Tuesday, March 29, 2011 7:29:41 AM UTC-4, Omri wrote:
I have found my problem - it was some stupid configuration problem.
But I will still want to leave the question open - What is the best way to
create a new 'clean' copy of the database file, resetting all the
auto-increment fields?
Another option for non-SQLite databases is to use truncate() on each table.
But you have to truncate() in the right order for tables that reference each
other, otherwise the truncate operation will fail.
Thanks for your quick reply!
Omri
4 matches
Mail list logo