Can this be used to dump a SQLite DB and Import into a MySQL DB? #240
-
|
I cannot see how to export the data, only the schema. I'm looking for a literal migration from one DBMS to another. |
Beta Was this translation helpful? Give feedback.
Answered by
amacneil
Sep 18, 2021
Replies: 1 comment 1 reply
-
|
No, for export you should check out mysqldump or sqlite .dump command. For import just run the generated sql file against the new database. |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Not that simple. Not by a long way. I couldn’t find a tool. I ended up editing all the SQL vim to make it compatible for MySQL import. |
Beta Was this translation helpful? Give feedback.
Answer selected by
warwickchapman
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
No, for export you should check out mysqldump or sqlite .dump command.
For import just run the generated sql file against the new database.