Is it possible to migrate from SQLite to MySQL?

Drone Support
1

Hey,

Been using Drone since v0.5 (currently on v0.8 RC5), it’s been chugging along fine. But odd cases pop up where a build stays building indefinitely and it can’t be cancelled. I usually dig manually into the sqlite file and remove the offending build from the SQLite.

I have been wanting to switch to using MySQL for a while now… Is there any way to migrate the SQLite data over to a MySQL DB? Or if there isn’t any easy way to do so… are there any particular differences I should know between the two before trying to manually migrate tables over?

2

mysql provides a database migration utility that you can use to migrate from sqlite to mysql. I have not used it personally, and am not sure how well it would work, but you can learn more at https://www.mysql.com/products/workbench/migrate/