Overview

This support article describes how to create a new MySQL database in Plesk and then import a MySQL backup into the newly created database. This is typically done when migrating a website or when moving from a local development environment to a live server.

Instructions

  1. Log into your Plesk server or Conetix Control Panel.
  2. Next click on the Databases button within the Dashboard tab:
    Plesk Obsidian - Create and import a MySQL Database
  3. Next, select  Add Database:
    Plesk Obsidian - Create and import a MySQL Database
  4. Enter the relevant details, Database Name, Related Site, Database User and Password and click Ok to create a new database.
    Plesk Obsidian - Create and import a MySQL Database
  5. Now that you have created your MySQL database, you can click on Import Dump to restore a MySQL backup:
    Plesk Obsidian - Create and import a MySQL Database
  6. Select your MySQL backup file either by browsing your local computer or under your hosting folder (if you have already transferred it via FTP):
    Plesk Obsidian - Create and import a MySQL Database
    MySQL will then import the database and display the progress.
    Plesk Obsidian - Create and import a MySQL Database
    Import completed.
    Plesk Obsidian - Create and import a MySQL Database
  7. You have now successfully created and imported a MySQL database.
    Plesk Obsidian - Create and import a MySQL Database
Was this article helpful?

Related Articles