HOW CAN I BACK UP MY WEBSITE AND MS SQL DATABASE?
You may download all your websites via FTP to y...
This tutorial assumes that you have already created a database. If you
have not, you will need to do...
BACKING UP A DATABASE
You can quickly and easily create a database backup using Plesk. When
you do ...
OPTIMIZING YOUR DATABASE TABLES
We will be demonstrating how to optimize your MySQL tables.
> NOT...
HOW TO REPAIR DATABASE TABLES
Before we start a repair of a database table, we want to first check
...
There are several ways to check the version of the MySQL service on
your account.
The first one is...
...
The MySQL trigger is a database object that is associated with a
table. It will be activated w...
This article describes how to use phpMyAdmin to change the collation
settings for MySQL databases an...
This article describes a problem that occurs after a server is
upgraded to MySQL 5.6.5 or later, and...
CONNECTION STRING WITH STANDARD SECURITY:
Data Source=SQL_SERVER_IP,MSSQL_PORT;Initial
Catalog=DATA...
Before you attempt to connect, make sure you have created a database
in your hosting account. To con...
Using SSH can be a superior way to manage the files and databases on
your account. Using a simple co...
MySQL database size limitations are applied for all shared hosting
plans, in order to ensure fair re...
It's very easy to rename a table in phpMyAdmin. To do so, simply
follow these steps:
*
Log in t...
STEP 1: BACKING UP THE DATABASES
Before you attempt to repair any database, you should back it up
f...
CREATING A DATABASE
To create a database, follow these steps:
1. Log in to Plesk.
2. In the lef...