Convert SQLite to MySQL

[CroaBeast]

Is there a way to convert a SQLite database to a MySQL one? I'm trying to move my server to a network but the FastLogin.db from my survival server does not work in the proxy FastLogin folder.

How can I properly set up FastLogin along with AuthMe in a network after those plugins were used in a standalone server?

[CroaBeast]

Also, how can I auto login players between servers to avoid login again everytime they join another server.

[games647]

The force login data is normally forwarded to every server join. However, this only happens if FastLogin logs you in. The server log shows the behavior of FastLogin. If you could provide the server log, we could explain it.

[CroaBeast]

@games647 there you go
2023-11-13-3.log

[games647]

Could you please highlight the player, time and log messages when it happens including from your proxy. Here it is hard to differentiate premium players.

[games647]

There is no official migration method, but you can do it manually using programs like SQLiteman to export your existing data and import it into MySQL using PHPMyAdmin or CLI.

[CroaBeast]

is there a tutorial on how to use them? those programs seem complicated

[games647]

1. Let FastLogin generate the table scheme on MariaDB/MySQL
2. Export your existing data to SQL file
   Here only the data is interesting, so select data only and the premium table.
   
3. Translate to the MySQL language
   Unfortunately, there are some language difference. Therefore replace BEGIN TRANSACTION -> START TRANSACTION and remove double quotes in the table name if existing.
4. Import the file to MySQL/MariaDB through PHPMyAdmin by selecting first the correct database on the left side and then click on the import tab, where you can upload the file.