Restore Database .sql form old panel to new panel with blueprint

can restore?
12 Replies
root@david1117:~#
It's possible
valid
valid15mo ago
mysql -u root -p panel < panel.sql
AssaultLine
AssaultLine15mo ago
Something that goes along with this a bit, what are the tables that blueprint adds into pterodactyl? I want to copy the configuration for my dev/testing panel over to my live panel now and need to figure out what tables to migrate so that I can keep config settings.
Growtoups | elixior.cloud
Why are you not just migrating the whole db
AssaultLine
AssaultLine15mo ago
Because the test panel has no users and my live panel has hundreds... i was setting up all of the blueprint and extensions to get it working and test things before it went to our live. I only wanted the config stuff for theme and extensions migrated.
Growtoups | elixior.cloud
Well in theory you could visually edit them But yeah idk
AssaultLine
AssaultLine15mo ago
Yeah but that defeats the point of the test panel to begin with then. I had everything ready to go and yeah I ended up having to reconfigure the whole theme and colors, upload all images, and change all settings again manually. The extensions DO NOT store in the database in any simple method of migrating them.
Growtoups | elixior.cloud
The point of having a test panel is to test things out so as far as I know it doesn't defeat the purpose of having one
AssaultLine
AssaultLine15mo ago
Not what I meant, I meant I sat and configured all the different extensions and fine tuned everything over a week and then just had to rush and do it all again because i wasn't able to migrate just a specific database table like I had originally thought it was. The columns/tables for each extension are all over the place in the database. It was going to be more risky even attempting to grab all the database data so I opted in redoing it all again from the start.
Growtoups | elixior.cloud
Obviously it wouldn't be only one table
Luke
Luke15mo ago
i mean, just import ur live db and migrate ur db Shrug

Did you find this page helpful?