How to Import and Export 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 to Set Player Idle Timeout on Your Minecraft Server
Learn how to automatically kick AFK players from your Minecraft server to free up slots and reduce resource usage.
How to Run Bukkit Plugins on a Fabric Server with Cardboard
Learn about Cardboard (formerly Bukkit4Fabric) for running Bukkit plugins on Fabric servers.