Re: [sqlalchemy] Locked file when trying to copy

Thanks a lot Lance, that did the trick. best regards, jeroen On Mon, Aug 16, 2010 at 10:18 PM, Lance Edgar lance.ed...@gmail.com wrote: See http://groups.google.com/group/sqlalchemy/browse_thread/thread/aa9c753384532e6c/8d070ff7208494b1 The solution though I believe is just: from

[sqlalchemy] Locked file when trying to copy

Hello all, I am trying to export data from a MySQL database to a sqlite database using SqlAlchemy. I am using 2 engines for each database ( from and to ). This is the part that creates the sqlite engine: to_engine = create_engine(u'sqlite:///%s'%temp_file_name) to_meta_data = MetaData()

Re: [sqlalchemy] Locked file when trying to copy

See http://groups.google.com/group/sqlalchemy/browse_thread/thread/aa9c753384532e6c/8d070ff7208494b1 The solution though I believe is just: from sqlalchemy import create_engine from sqlalchemy.pool import NullPool to_engine = create_engine('sqlite:///%s' % temp_file_name, poolclass=NullPool)