LuckPerms

LuckPerms

41.4k Downloads

[LP] A database error occurred whilst loading permissions data. Please try again later.

GopnikJr opened this issue ยท 3 comments

commented

Anytime anyone tries to log on, I get this:
https://pastebin.com/PXzQLsyz

I have tried restarting the server with no luck of it fixing.

commented

I'm sure the problem isn't in LuckPerms. Read this article related to this error: https://github.com/lucko/LuckPerms/wiki/Storage-system-errors#luckperms-cannot-connect-to-my-mysql-server

commented

Yeah, you were right. I had to recreate the MySQL database because I guess something went wrong? Would you know of any way to grab the old database information without having to redo all perms?

commented

Yeah, you were right. I had to recreate the MySQL database because I guess something went wrong? Would you know of any way to grab the old database information without having to redo all perms?

With LuckPerms

Connect your LuckPerms to old database and enter this command:
/lp export <filename>
You can find it in ../plugins/LuckPerms/<filename>json.gz
Then reconnect LuckPerms to new database and enter this command:
/lp import <filename>

Other ways

You can export tables of LuckPerms with phpMyAdmin function called "Export":
image

or if you don't have PMA, you can do it with command prompt through SSH:
https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt

Then you will get .sql dump which you can import in new database.