How do I move player files into a database?

[BBmine]

Hi, my servers have their player files as actual files. How can I put them in a database?

[ExeterDad]

From the minetest --help command:

--migrate-players <value> Migrate from current players backend to another (Only works when using minetestserver or with --server)

So start the server with: minetestserver --migrate-players sqlite if you are using a sqlite database.
I don't remember if:
player_backend = sqlite3
is added automatically to the world.mt file or if you need to add it. I'm thinking I added it when I migrated.

Be warned though. Editing player data once it's in the database is no longer trivial. You'll have to learn to use the database in command line mode or have some nice scripts.

[BBmine]

From the minetest --help command:

--migrate-players <value> Migrate from current players backend to another (Only works when using minetestserver or with --server)

So start the server with: minetestserver --migrate-players sqlite if you are using a sqlite database.
I don't remember if:
player_backend = sqlite3
is added automatically to the world.mt file or if you need to add it. I'm thinking I added it when I migrated.

Be warned though. Editing player data once it's in the database is no longer trivial. You'll have to learn to use the database in command line mode or have some nice scripts.

Be advised I've messed around with mysql commands. It's probably not that bad :D

[maikerumine]

How exactly to I migrate all the player files into the sqlite3 file? Can I do this in game as admin?

[maikerumine]

Is there documentation on how to do this?

[rubenwardy]

Is there documentation on how to do this?

./path/to/minetest --server --worldpath path/to/world --migrate-players sqlite

[maikerumine]

Is there documentation on how to do this?

./path/to/minetest --server --worldpath path/to/world --migrate-players sqlite

I originally tried this in both my auto restart and by itself but still no result.
Does it matter that I am running the server on a windows machine?
Do I need any other sqlite program added to my machine?
the path to world name that works for me is: --worldname , not --worldpath, is this a typo?

Sorry for all the questions, I just cannot get this to work.

Code: Select all

-------------
  Separator
-------------

2017-10-15 09:17:45: [Main]: Using world specified by --worldname on the command line
2017-10-15 09:17:45: ERROR[Main]: An error occured during migration: Database backend sqlite not supported.

WAIT!! I think it worked: --server --worldname SAS --migrate-players sqlite3

then i changed my world.mt file to accept sqlite3 instead of files.