How to Import and Export MySQL Database

MySQL Databases are one of the many ways to store server data, commonly used by plugins.

Your Shockbyte server comes with a free MySQL database that can be used to store new or existing data. If you do not have one yet, you can create a MySQL Database by following this tutorial: Creating a MySQL Database

Logging Into phpMyAdmin

Before getting started with this tutorial, log into phpMyAdmin where you can manage your MySQL database by following the steps below:

  1. Log into your Multicraft control panel account. If you own more than one server, select the server on which you want to import your database into. 
  2. On the left sidebar of your control panel, navigate to Advanced > MySQL Database
  3. On the MySQL Database page, click on the Administration Link to log into phpMyAdmin.
  4. Log into your phpMyAdmin account by entering your MySQL Username and Password then click Go.



Importing a MySQL Database

Importing is a very handy way to store existing data from another server into your server's own database. The steps below will show you how to import an existing MySQL database:

This tutorial assumes you already have an existing exported database_name.sql file. If you do not have one yet, scroll down to the section on Exporting a MySQL Database.
  1. On your phpMyAdmin page, select the database you want to import data into by clicking on the database name from the left sidebar.
  2. Once you've selected the database, click Import found on the top navigation bar. 
  3. On the import page, click Choose File to browse and select the .sql file from your computer that you would like to import, make sure you have selected SQL under the Format section and then, click Go.
  4. If importing is successful, you will be redirected to a page with a message indicating that import was successful along with all the actions executed. You will also see your data tables shown on the left sidebar under the database name. 
    MySQL DB - Successful import

You're done! You can now use the imported data into your server. 


Exporting A MySQL Database

If you want to backup of your data or import it into another database, you may do so by exporting your MySQL database. 

  1. On your phpMyAdmin page, select the database you want to export by clicking on the database name from the left sidebar.
    MySQL DB - Select the database

  2. Once you've selected the database, click Export found on the top navigation bar.
    MySQL DB - Navigate to Export page

  3. On the Export page, make sure your Export method is set to Quick and the Format is set to SQL and click Go. This will automatically download your database into your computer.

    If you are familiar with managing MySQL databases, or you only want to choose specific tables to be exported, you may select the Custom export method.
    MySQL DB - Export database

That's it! You've successfully exported your MySQL database. The exported SQL file is now ready to be imported into another database or simply be stored as a backup. 

Looking for more MySQL guides? Click here! 

If you require any further assistance, please contact our support at: https://shockbyte.com/billing/submitticket.php

Mitchell Smith

Managing Director @ Shockbyte

  • MySQL, Database, plugins, minecraft server, storage, phpMyAdmin, Multicraft, MySQL Database
  • 11 Users Found This Useful
Was this answer helpful?

Related Articles

Creating a MySQL Database

Every server comes with a free MySQL Database. This database can be managed in the Multicraft...

How to Import a MySQL Database Backup (.sql File)

If you are moving to Shockbyte from another host or have an existing database you wish to move to...