How to Import and Export Minecraft MySQL Databases with phpMyAdmin
Learn how to back up and restore MySQL databases used by your Minecraft server plugins.
phpMyAdmin lets you manage your MySQL databases through a web interface. You can export databases as backups and import them to restore data.
Exporting a Database (Backup)
Open phpMyAdmin
Access the XGamingServer panel, go to Databases, and click the phpMyAdmin link for your database.
Select your database
Click on your database name in the left sidebar.
Export
Click the Export tab, select SQL format, and click Go. Save the .sql file to your computer.
Importing a Database (Restore)
Open phpMyAdmin
Go to Databases and open phpMyAdmin.
Select your database
Click your database name in the left sidebar.
Import
Click the Import tab, choose your .sql file, and click Go.
⚠️ Warning: Importing overwrites existing data in the tables. Export a fresh backup before importing if you want to keep current data.
💡 Tip: Export your database regularly as a backup, especially before major server updates or plugin changes.
See also: Use MySQL Database
If you need help, join our Discord.
How is this guide?
How Much RAM Does Your Minecraft Server Need?
RAM recommendations for Minecraft Java servers based on player count, server type, mods, plugins, and world complexity.
How to Run Bukkit Plugins on a Fabric Minecraft Server with Cardboard
Learn about Cardboard (formerly Bukkit4Fabric) for running Bukkit plugins on Fabric servers.