How to Manage Databases Within the Plesk Webhosting Panel

How to Manage Databases Within the Plesk Webhosting Panel

Introduction

Plesk is a great tool that can allow you to manage your databases for any domain that has been added to your Plesk hosting account. You can manage PostgreSQL or MySQL databases directly using Plesk. Some database tasks like create, edit, and import and export databases can be easily managed.

This article will walk you through how to manage databases with the Plesk panel.

Prerequisite

  • Plesk Account
  • Registered domain added to Plesk panel.

Getting Started

Login to your Plesk panel using your name and password. On the left-hand side of the panel, click Databases.

How to Manage Databases With Plesk Panel

Here, you will find a list of all your databases. There are three options defined below;

  • User Management – this option allows you to add or remove database users.
  • Database Servers – this option lets you add and reset servers as well as change the settings of your available servers.
  • Backup Manager- this option allows you to backup, upload, remove and schedule backups. You can configure your remote storage settings and also install the likes of Dropbox and AWS here.

Creating A Database

To add a database, click on Add Database.

How to Manage Databases With Plesk Panel

Enter the below details about your database;

  • A name
  • A related site
  • Create a database username
  • Give the user a password
  • Confirm the password

How to Manage Databases With Plesk Panel

  • Configure access control
  • Click okay

How to Manage Databases With Plesk Panel

You should now get the following;

How to Manage Databases With Plesk Panel

Editing Tables Using phpMyAdmin

Login to your plesk account and head over to the databases tab. You should see the databases and/or domains listed here. Click on the one you wish to edit and click phpMyAdmin.

How to Manage Databases With Plesk Panel

The phpMyAdmin will allow you to create tables amongst other things such as exporting and importing settings.

How to Manage Databases With Plesk Panel

Once you are done, save your settings, and they will be reflected at the plesk control panel.

Connection Info

You can click on this option whenever you want to link a web app to your database. Clicking on gives you details about your database; host, database name, username and password.

How to Manage Databases With Plesk Panel

Copy

This option is used whenever you want to copy the contents of the database into another database. You can select the destination database and its server and specify if you want the copy tool to copy everything.

How to Manage Databases With Plesk Panel

Exporting a Dump

Click Databases then choose a database to export. Then click Export Dump.

How to Manage Databases With Plesk Panel

You will be prompted to select the location the dump is going to be saved to, then select a name for the dump. Optionally you can choose to download the dump after creation.

How to Manage Databases With Plesk Panel

Click OK. A small pop-up window will appear at the bottom right of your screen confirming the procedure is happening.

How to Manage Databases With Plesk Panel

Importing a Dump

Choose the database you want to import to and then select Import Dump.

How to Manage Databases With Plesk Panel

Here you can select upload if you opted to save the dump in offline. If you saved the file in one of your directories, you could browse for it by choosing Import and navigating to the folder where you saved the dump. In My case, I saved it at the root directory. Select the dump and click OK.

How to Manage Databases With Plesk Panel

A small pop-up message at the bottom right of the screen will show you the progress of the import.

Repairing a Database

Whenever your database has lost something or it isn’t running well, click this option. It automatically checks and tries to repair any part of the database that might be having trouble.

How to Manage Databases With Plesk Panel

Deleting a Database.

Navigate to the databases tab and choose the database you want to remove. Then click Remove Database.

How to Manage Databases With Plesk Panel

How to Manage Databases With Plesk Panel

Conclusion

We have gone through what you need to know when managing databases that include; how to create, edit, and import and export databases using Plesk.  Simplify your database management with Plesk.

Check out these top 3 cPanel hosting services:

Hostinger
$2.99 /mo
Starting price
Visit Hostinger
Rating based on expert review
  • User Friendly
    4.7
  • Support
    4.7
  • Features
    4.8
  • Reliability
    4.8
  • Pricing
    4.7
HostArmada
$2.49 /mo
Starting price
Visit HostArmada
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.5
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.0
FastComet
$1.79 /mo
Starting price
Visit FastComet
Rating based on expert review
  • User Friendly
    4.7
  • Support
    5.0
  • Features
    4.8
  • Reliability
    4.5
  • Pricing
    5.0

How To Set Up Database Custom Access Rules in Plesk

This article will show you how to set up database custom access rules in Plesk.
2 min read
Elizabeth Njoroge
Elizabeth Njoroge
Author

How to Install MySQL on a Windows Web Server Running Apache

This tutorial will show you how to install the MySQL database on a Windows serve
3 min read
Michael Levanduski
Michael Levanduski
Expert Hosting Writer & Tester

How To Install MySQL on Windows

This how-to article teaches you how to install MySQL on Windows.
4 min read
Avi Ilinsky
Avi Ilinsky
Hosting Expert

How to Move Your WordPress Site from Your Local Web Server to Your Live Site

You can always accelerate the development process by developing your WordPress s
4 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top