Re: Copy data from tmp db to real db; Easy way?
TiNo <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
Yes I ment programmatically. During the program I gather some data in a temporary database. The user can choose to import this data in the definite db. 2006/11/14, Rich Shepard <[email protected]>: > On Mon, 13 Nov 2006, TiNo wrote: > > > I need to copy data from my temporary database to the definite db. I can > > do this by selecting all data, create new insert statements and execute > > those. But I have a feeling that their is an easier way. Something like > > dumping, buth without the table building statements. What is the easy way > > to do this? > > TiNo: > > Do you want to do this programmatically or manually? If the former, more > experienced folks will need to advise you. If the latter, just 'cp > oldfile.db newfile.db'. > > Rich > > -- > Richard B. Shepard, Ph.D. | The Environmental Permitting > Applied Ecosystem Services, Inc.(TM) | Accelerator > <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 > _______________________________________________ > pysqlite mailing list > pysqlite-IAPFreCvJWPBWskQ1e/[email protected] > http://lists.initd.org/mailman/listinfo/pysqlite >