How to manage databases with the Webadmin in Plesk

Parallels Plesk Panel 11 end-user series

27. How to manage databases with the Webadmin in Plesk

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

1) Go to the websites & domains tab.

2) Then click databases.

3) And then choose 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.

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 is the end of the tutorial. Now you know how to access the webadmin for a database in Plesk.

How to create databases in Plesk

Parallels Plesk Panel 11 end-user series

26. How to create databases in Plesk

If your website incorporates custom data processing applications or is designed to generate web pages dynamically, you will likely need a database for storing and retrieving data.

1) Go to the websites & domains tab.

2) Then click databases.

3) Click add new database.

4) Enter the database name.

5) Choose the type of database and the database server.

6) Click ok.

After the database is created, we need to add at least one user that has permission to access it.

7) Click add new database user.

8) Type the username and password.

9) Click ok.

Once you have created at least one user, you can choose one to use as the default for the database webadmin.

10) Click the checkbox next to a username.

11) Click this button.

This is the end of the tutorial. Now you know how to create a database and add users to it.

How to set up scheduled tasks (cron jobs) in Plesk

Parallels Plesk Panel 11 end-user series

25. How to set up scheduled tasks (cron jobs) in Plesk

Scheduled tasks allow you to set up scripts to run automatically on your server.

1) Go to the websites & domains tab.

2) Click scheduled tasks.

You will see your system user account which is created automatically by the system when your subscription is created.

3) Click on your username.

4) We’ll adjust the settings first by clicking this icon.

5) Choose if you want to be notified from the scheduler each time a task runs. You can choose the default system email or your own email.

6) Click ok.

7) Now let’s schedule a new task.

8) Enter the date and time you want this task to run.

9) Now enter the command you want to execute.

10) Click ok.

The task has been created and automatically switched on.

11) To switch off a task, click the green arrow.

That’s it! Now your scheduled task is switched off.

This is the end of the tutorial. Now you know how to create scheduled tasks in Plesk.

How to password protect a directory in Plesk

Parallels Plesk Panel 11 end-user series

24. How to password protect a directory in Plesk

Password protecting a directory is useful if you want only a select few people to be able to access it using the login info you specify.

1) Go to the websites & domains tab.

2) Click show advanced operations.

3) Click password protected directories.

4) Click the corresponding manage link next to the domain.

5) Click add protected directory.

6) Enter the directory name here.

7) Click ok.

Now that the directory has been created, we need to create users each with their own username and password.

8) Select the directory.

9) Click add new user.

10) Enter a username.

11) Enter a password here and confirm it.

12) Click ok.

The user account, for access to the protected directory, was created successfully. Feel free to create a user for each person you want to be able to access the directory.

This is the end of the tutorial. Now you know how to password protect a directory in Plesk.

How to use the backup manager in Plesk

Parallels Plesk Panel 11 end-user series

23. How to use the backup manager in Plesk

Backups are an essential part of maintaining any website. It is important to create backups on a regular basis to prevent data loss in the event of a server crash.

1) Go to the websites & domains tab.

2) Click backup manager.

3) Click back up.

You cannot specify the file name for the backup, but you can add a prefix to help you find it later.

Optionally add descriptive text about this backup in the comments section.

4) Specify the volume size to create a multivolume backup.

By default, backups will be stored on the same server as your account. You could also perform a remote backup by choosing personal FTP repository. You’ll need to set one up first in order for this option to become available; we’ll show you how to do that in a moment.

5) Enter an e-mail address here to which a notification will be sent upon task completion.

6) Choose whether to back up just the configuration or both configuration and content.

7) Click back up.

Depending on the amount of data you have, this can take some time. While we wait, let’s see how to create scheduled backups.

8) Go to scheduled backup settings.

9) Check this box to activate this task.

10) Choose how often this task should be performed; either daily, weekly or monthly.

11) Set the time and day of the week when this task should begin.

So, according to these settings, a backup will automatically be made every week starting at 05:17PM on Mondays.

12) Optionally add a prefix to the backup name.

13) Click ok.

The manual backup we made in the first part of this tutorial has finally finished and is shown here.

Now let’s see how to set up a personal FTP repository so we can perform remote backups via FTP.

14) Click this link.

15) Enter the server’s IP address or hostname.

16) Then type the username and password.

For security purposes, you can also password protect your backups. Note that if you forget the password, it cannot be recovered.

17) Click ok.

Now that we know how to create backups, let’s learn how to restore them.

18) Click server repository.

19) Choose the backup file that should be restored.

20) Select the type of data to restore.

21) Optionally enter an e-mail where a notification will be sent upon task completion.

22) Click restore.

If there are any conflicts, they will show up here.

23) Click next.

24) Choose what to do with the conflicts; use configuration and data from the backup file, use the configuration from the current system and restore only the data from the backup, or do not restore any objects that have conflicts.

25) Click next.

The backup is being restored.

We have seen how to make and schedule backups for our account and websites and how to restore them. Let’s quickly take a look at how to back up a single subscription.

26) Go to webspaces.

27) Choose the subscription you want to backup.

28) Click back up websites.

A few moments ago, we restored a backup, which has completed now, as you can see.

This looks exactly the same as the account-wide backup manager, but the tools available to us here are specific to the subscription we selected. This means the scheduled backup settings and personal FTP repository settings we just entered are separate and will not show up here.

29) Click back up.

You can choose whether to back up just the domain configuration or both configuration and content. Selecting the second option gives you the choice of including mail in the backup or excluding it.

30) Fill out all the options as we did previously.

This is the end of the tutorial. Now you know how to use the backup manager in Plesk.