sqlite3-to-mysql
sqlite3-to-mysql copied to clipboard
Insert values only
Is your feature request related to a problem? Please describe. See #39
Describe the solution you'd like The user may create the table by its own to the targetted mysql database and run the sqlite3mysql command only to migrate rows. Therefore the column datatypes can be finely tuned.
Describe alternatives you've considered
- Instead, we could introduce an option to only dump the sqlite db and let the user transform the result.
- Or one could use the project as a python dependency and override
SQLite3toMySQL
for specific needs.
Additional context
This is already possible, I believe.
Let me see if I understand you correctly:
- You have your MySQL database in which you create a table called
new_table
. - Your SQLite database also has table
new_table
. - You only wanna transport table
new_table
from SQLite to MySQL.
Run the following
sqlite3mysql -f input.db -d output -u root -p -t new_table
Let me know if that works for you.