RSS Feed
Knowledgebase : Database

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...
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...
Copyright © 1998 - 2018 Shinjiru International Inc. All Rights Reserved.