Portal Home > Knowledgebase > Database Management

Articles

 Can I connect to SQL database using SQL Server Management Studio?

Yes, you can use Microsoft SQL Server Management Studio to remotely connect with your database on our server. However, you need to send an email to support with connecting IP address so we allow it...

 Configuring ODBC

The Open Database Connectivity (ODBC) is an interface used to access data from a variety of database management systems. For example, if you have a program that accesses data in a SQL database,...

 How do I manage MySQL Databases using PhpMyAdmin in cPanel?

Managing a MySQL database in PHPMyAdmin In this article, we'll give a brief introduction to phpMyAdmin, a web based mySQL client you can use to manage your databases. There are many tools and...

 How to Backup and Restore Microsoft SQL Server Database?

This article applies to: Plesk 9 Plesk 10 The Windows hosting plan comes with a web-based management tool designed for MS SQL Server. Now you can manage your own databases, including...

 How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. In "New Database: Username_" field enter a name for the new database you wish to create in...

 How to restore SQL Server 2012 database on SQL Server 2008 R2

Restoring Backups of SQL Server 2012 databases on SQL Server 2008 R2  Applies to: SQL Server 2012 SQL Server 2008 R2   Generating Scripts For SQL Server 2012 in compatibility mode for SQL...

 How To Take Backup Or Restore Backup of MS-SQL Database

Taking Backups & Restoring of SQL databases using Plesk Applies to: Plesk 9 Plesk 10   Backup/Restore using Plesk 9: For taking backup: Login to your Control Panel Go to specific...

 Managing Databases

With Plesk you can create multiple databases and multiple users within each database, and make use of DB WebAdmin - a web-based administration tool, allowing you to sort, edit, and create tables...

 Plesk - How to Backup Databases

  With Parallels Plesk Panel, you can back up and subsequently restore the databases, database user accounts and data used by domains hosted on your server. You can: Back up your domain...

 [PLESK 11] How to Backup and Restore Microsoft SQL Server Database

This article applies to PLESK 11 Following are the steps to Get backup and Restore the Microsoft SQL Server database:Login to the Plesk > click on the domain > On the top of the right...

 [PLESK] How to Back and Restore Microsoft SQL Server database

With Parallels Plesk Panel, you can back up and subsequently restore the databases, database user accounts and data used by domains hosted on your server. You can: Back up your domain databases...

 How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "Current Databases", You can see list of your all databases. Locate the Database and...

 How to delete a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "Current Databases" you can see a list of all your databases. Locate the Database you...

 How to Create a Database Username in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "MySQL Users" in the "Username" field enter the new username you wish to create.4....

 How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Scroll down to the end of the page and under "Add User to Database", select a user from the...

 How to import database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example". 4. Under your cPanel...

 How to export database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example". 4. Under your cPanel...

 How to edit database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example".4. Under your cPanel...

 How to delete database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example". 4. Under your cPanel...

  How to optimize database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example". 4. Under your cPanel...

 How to Repair database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In left side-bar, Click on the expand button to expand database like "example".4. Under your cPanel...