Just to the company 1 weeks then received the first demand, into a few days of communication understand is from the GBK file to recover the InterBase database, and then restore to the database data exported to the remote MySQL database, get the need to step to see the problem, the problem can be broadly divided into three steps, Each step of a script file is divided into three Python files to execute.
The first script implements a command to restore the ". GBK" Database backup file to ". GDB "format database file with the following command:
Python restorewin.py-gbk backup file-gdb recovered database
The second script implementation exports the data from the InterBase database to a text file (. txt) that can be recognized by MySQL, with the following command:
Python output.py-i configuration file-O export file
The third script implementation imports the exported text file into the remote MySQL database via the SQLAlchemy framework on Python, with the following command:
Python inputdb.py-f files to import
For my later convenience memories, I will be divided into three separate narrative three files of the content and attention to issues and problems encountered.
InterBase database migration to MySQL (description)