sqlite3-to-mysql icon indicating copy to clipboard operation
sqlite3-to-mysql copied to clipboard

Insert values only

Open fflorent opened this issue 2 years ago • 1 comments

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

fflorent avatar Mar 30 '22 12:03 fflorent

This is already possible, I believe.

Let me see if I understand you correctly:

  1. You have your MySQL database in which you create a table called new_table.
  2. Your SQLite database also has table new_table.
  3. 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.

techouse avatar Mar 30 '22 14:03 techouse