How to manage databases with the Webadmin in Plesk

Parallels Plesk Panel 10 end-user series

How to manage databases with the Webadmin in Plesk

To manage your databases and their contents, use your favorite MySQL, PostgreSQL, or Microsoft SQL Server client or the web-based database management tool accessible from the Panel, also known as the Webadmin.

1) You can find that by going to Websites & Domains.

2) Then Databases.

3) And then choosing a database to edit.

Note that you will need to have a user assigned to the Webadmin in order to access it.

4) Click Webadmin.

5) Since our database is a MySQL database, Plesk has taken us to the phpMyAdmin start page. Use the various tabs and links to manage your database.

This tutorial is complete. You now know how to access the Webadmin for a Database in Plesk.

Copying a database table with phpMyAdmin

phpMyAdmin series

Copying a database table with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to copy a database table

Click the database table you wish to copy

Then click the Operations button

When copying a table, you can choose to copy the table structure only, the data only, or both. Enter a name for the new table here, then click Go

Copying a table actually creates a new table altogether (that’s identical to the one we’re copying)….. so we have to give a name for the new table

That’s it! A new table has been created, and it is a perfect copy of the original. Both tables are now listed here

This is the end of the tutorial. You now know how to create a copy of a database table using phpMyAdmin

Creating tables in a database with phpMyAdmin

phpMyAdmin series

Creating tables in a database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to create a table within a database

Select thedemo1234_members database here

Enter a Name for our new table

Then enter the number of fields this new table is to have. Click Go

Now enter the details of each field within the new table

We also want this first field to be the Primary key that will be automatically filled in (auto_increment) when new entries are added to the table

The first field will be called id, and it will be an integer that’s 4 characters in length

Selecting this option makes the id field the Primary key in the table

The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accomodate the fields

When finished, click Save

That’s it! Our new table (details) has been successfully created within our database(demo1234_members) as indicated here

This is the end of the tutorial. You now know how to create new tables within a database using phpMyAdmin

Deleting fields from database tables with phpMyAdmin

phpMyAdmin series

Deleting fields from database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to delete fields from database tables

Select the details table here

Let’s delete the city field

Click the Delete (or Drop) icon

Click Yes to confirm

That’s it! We’ve successfully deleted the city field from our database table

This is the end of the tutorial. You now know how to delete fields from database tables using phpMyAdmin