Importing and exporting a MySQL database using phpMyAdmin for Minecraft is crucial for maintaining efficient data management. Importing a database involves transferring important information, including player data, inventory, and world details, from a backup or another server, preserving game progress. Conversely, exporting a database enables creating backups or migrating data to an alternate server or platform.
Requirement: To create a database, see here.
How To Export a MySQL Database
Step 1. Log in to the MelonCube Games panel.
Step 2. Go to the Databases tab on the left.
Step 3. Click Edit from the preferred database.
Step 4. Take note of the Username and Password fields.
Step 5. Click the PhpMyAdmin button at the bottom.
Step 6. Log in with the Username and Password from Step 4. The login will fail if the server choice does not match the database server type.
Step 7. Open the Export tab.
Step 8. From the Export Method table, click Quick. Custom is used for advanced options.
Step 9. Choose the preferred Export format. SQL is the default database format.
Step 10. Click the Export button.
How To Import a MySQL Database
Step 1. Log in to the MelonCube Games panel.
Step 2. Go to the Databases tab on the left.
Step 3. Click Edit from the preferred database.
Step 4. Take note of the Username and Password fields.
Step 5. Click the PhpMyAdmin button at the bottom.
Step 6. Log in with the Username and Password from Step 4. The login will fail if the server choice does not match the database server type.
Step 7. Open the Import tab.
Step 8. From the File to import: table, upload the preferred .sql file or zip.
Note: If the file to import is custom, choose the character set and format manually.
Step 9. Click the Import button.