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 at https://mc.shockbyte.com. 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

    MySQL - Navigate to MySQL Database page

  3. On the MySQL Database page, click on the Administration Link to log into phpMyAdmin.

    MySQL - Administration Link

  4. Log into your phpMyAdmin account by entering your MySQL Username and Password then click Go.

    MySQL db - Log into phpMyAdmin


IMPORTING A MYSQL DATABASE

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

Note: 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.

    MySQL DB - Select the database

  2. Once you've selected the database, click Import found on the top navigation bar. 

    MySQL Database - Import

  3. On the import page, click Choose File to browse and select the .sql file from your computer that you would like to import. 

    MySQL DB - Choose sql file

  4. After selecting your SQL file. Make sure you have selected SQL under the Format section, then click Go.

    MySQL DB - Import database

  5. 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. 

If you encounter difficulties managing MySQL database, feel free to contact us!

 

Mitchell Smith

Managing Director @ Shockbyte

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

Related Articles

Multicraft User Roles

You can allow a friend or another user to manage your server by adding them as a additional user...

Creating a MySQL Database

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

Giving Operator (OP) to a Player

We have a video tutorial for giving OP to a player:   An operator (OP) is someone who has...

Adding Extra Control Panel Users

We have a video tutorial on how to add users on Multicraft:   You can give a friend or server...

How to Manually Backup Your Minecraft Server

We have a video tutorial for creating a backup:   Backups can be used to recover your server...

Powered by WHMCompleteSolution