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() to_meta_data.bind = to_engine Then i move the tables from one engine to the other. I close the connections; to_connection.close() Finally i want to copy the sqlite file to its permanent location using shutil.move. But here it goes wrong; the file seems to be locked still: shutil.move(temp_file_name, self._filename) I get this error (might not be verbatim): WindowsError: [Error 32] The process does not have access to the file because the file is being used by another process. Can anyone give direction as to why the file might still be locked and how to avoid it? Thanks in advance, Best regards, Jeroen -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
