I’ve been trying to transfer from sv.db -> a MariaDB (MySQL) database on PHPMyAdmin.
First, I tried dumping the sqlite and importing it. Doesn’t work since the syntax between SQLite and MySQL is different (e.g. MANY errors such as AUTOINCREMENT becomes AUTO_INCREMENT, START TRANSACTION isn’t needed, all keys need length specified etc), and the data I am importing contains player names, with problems such as people ending their name with /, which makes the speech marks after their name be ignored and messes up all SQL after, and also people putting speech marks in their names.
I then tried the first 2 pages of google search results for tools to convert it. The only one I had any luck with was MySQL workbench, that failed at the end with ‘sqlite3.OperationalError: near “USE”: syntax error’
Any tried and tested solutions to upload from SQLite to MySQL?
(The only luck I have had is manually importing individual tables as .CSV, however this also breaks with some characters, and I have a LOT of tables to import by hand, having to rename them all manually after because PHPMyAdmin doesn’t take table name from the file. A way to loop through them, renaming them based on file name would be a nice solution too)