CONNECTION STRING WITH STANDARD SECURITY:
Data Source=SQL_SERVER_IP,MSSQL_PORT;Initial
Catalog=DATABASE_NAME;User
Id=DATABASE_USER;Password=DATABASE_USER_PASSWORD;
ALTERNATIVE SYNTAX 1:
Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User
ID=DA...
HOW CAN I BACK UP MY WEBSITE AND MS SQL DATABASE?
You may download all your websites via FTP to your local PC. To
access the MS SQL server, we will send you the configurations for MS
SQL upon request and you will be able to remotely access the server
a...
BACKING UP A DATABASE
You can quickly and easily create a database backup using Plesk. When
you do this, Plesk exports the database as an SQL file.
To back up a database using Plesk, follow these steps:
1. Log in to Plesk.
2. In the left sidebar, c...
This article describes how to use phpMyAdmin to change the collation
settings for MySQL databases and tables.
ABOUT CHARACTER SETS AND COLLATION
MySQL enables you to store and process data in a wide variety of
languages using various character sets. Fo...
There are several ways to check the version of the MySQL service on
your account.
The first one is via a PHP script. You have to create a new file on
your account, for example mysql.php, and inside it place the
following:
1
2
3
4
5
6
7
8
9
10...
Before you attempt to connect, make sure you have created a database
in your hosting account. To connect to your SQL database using SQL
Server Management Studio (SSMS), follow the steps listed below:
* Open SQL SERVER MANAGEMENT STUDIO, the CONNECT TO ...
This tutorial assumes that you have already created a database. If you
have not, you will need to do so first. To import a database into an
existing database (.sql file) in cPanel using phpmyadmin follow the
steps below.
* Log into your cPanel account...
CREATING A DATABASE
To create a database, follow these steps:
1. Log in to Plesk.
2. In the left sidebar, click DATABASES. The DATABASES page appears.
3. Click ADD DATABASE. The ADD A DATABASE page appears.
4. In the DATABASE NAME text box, type ...
OPTIMIZING YOUR DATABASE TABLES
We will be demonstrating how to optimize your MySQL tables.
> NOTE: Some tables can not be optimized.
1) Log into your cPanel and select the PHPMyAdmin icon.
2) Select the database you wish to optimize.
3) Select the...
MySQL database size limitations are applied for all shared hosting
plans, in order to ensure fair resource usage. The limitation is 1GB.
If a database on your account has exceeded the database size
limitation (or it is getting close to reaching the limi...
It's very easy to rename a table in phpMyAdmin. To do so, simply
follow these steps:
*
Log in to cPanel.
*
From the DATABASES section, click on the PHPMYADMIN icon.
*
In the narrow left column, select the database containing the table
you wis...
STEP 1: BACKING UP THE DATABASES
Before you attempt to repair any database, you should back it up
first. To back up all of the files from all of your databases, follow
these steps:
* Log in to your server using SSH.
* Stop the MySQL server using th...
HOW TO REPAIR DATABASE TABLES
Before we start a repair of a database table, we want to first check
to see if we have to do it.
1) Log into your cPanel and select the PHPMyAdmin icon.
2) Select the database you wish to check.
3) Select the tables you...
Using SSH can be a superior way to manage the files and databases on
your account. Using a simple command you can import or export a MySQL
database into an existing database on your account.
Please note that in the examples below the -P will prompt for ...
This article describes a problem that occurs after a server is
upgraded to MySQL 5.6.5 or later, and how to resolve it.
PROBLEM
When you try to access a database on a server running MySQL 5.6.5 or
later the login fails, even though you are using the co...
...
The MySQL trigger is a database object that is associated with a
table. It will be activated when a defined action is executed for the
table. The trigger can be executed when you run one of the following
MySQL statements on the table: _INSERT, UPDAT...
