Learn how to manage your databases in the Account Control Center:

Transcript:

Today we’re going to go over managing your databases. So, if you log in to the Account Control Center and go over to the left sidebar, you’ll see Databases. Click this and then click Manage Your Databases in the drop-down. If you haven’t created a database yet, this option will not be available you. Clicking Manage Your Databases will take you to a list of your databases.

Click the name of one of your databases. This takes you to the management page for that database. Most of your management tools are located up here on this toolbar.

The first option here – phpMyAdmin – will take you to a phpMyAdmin, a database management tool that helps you edit the backend of the database.

The second option is Optimize. Clicking Optimize will rebuild your tables, which frees up space and defragments the data. This can help reduce performance problems.

After that, we have Backup. This option will create a complete database backup in the backup directory on your account.

The next option is Change Password. Use this option if you want to change the password for this database. Note that this does not affect your ACC account’s password.

After that, we have the Purge option. This option will delete all information stored in this database. This information cannot be restored once it is purged.

Lastly, we have Delete. Delete is used to delete the entire database. Databases that have been deleted will no longer count towards your database limits.

Now that we’ve covered the toolbar, we’re going to briefly talk about the options underneath it. You’ll see some details about your database down here, like server and users. There are also options to manage your database here, too.

Next to Disk Usage, there is a View History button. The View History button takes you to an overview of the database’s disk usage amount for the past months.

Going back to the main management page, you will also see a Change Access option next to a drop-down selection. This drop-down selection is for determining what kind of connections the database will accept. For example, Local Only will only allow connections from servers at pair Networks to access the database. Local/Remote allows connections from anywhere. You can select Local Only or Local/Remote from the drop-down and then click Change Access to make changes to your database’s access.

At the bottom of the page details is the Change Optimization option. This gives you the ability to change how often the database optimizes. The drop-down next to it allows you to select the frequency: monthly, biweekly, or weekly.

And that’s it! If you have any questions, check out our Knowledgebase or email our support team at support@pair.com.