MySQL

Backup and Restore Mysql Database using Mysqldump
Below are mysqldump commands for backup and restore mysql database: WINDOWS: Backup: C:\mysql\bin> mysqldump -u username -p password database > d...
Wed, 25 May, 2016 at 3:46 PM
Backup/restore MySQL databases from cPanel
Backup/restore MySQL databases from cPanel  To backup the databases please do the following: 1.Login to your control panel and click Backups. ...
Wed, 25 May, 2016 at 3:47 PM
MySQL Trigger and View
Trigger.  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 tab...
Wed, 15 Jun, 2016 at 9:02 AM
Connection Strings for MySQL
Cold Fusion (DNSless): connectstring="Driver={MySQL ODBC 3.51 Driver};SERVER=serverIP;UID=user;PWD=pass;DATABASE=mydb;network=dbmssocn" OR c...
Tue, 19 Dec, 2017 at 12:36 PM
Does your server support MySQL Front?
The answer is "Yes", our Windows and Linux server do support MySQL Front through Port 3306. However external IP has to be set up in CPanel...
Wed, 25 May, 2016 at 4:32 PM
How To Allow MySQL Remote Host in cPanel
This article will show the steps on how you can allow remote access to the database server from home or anywhere outside your office.   1) Login into you...
Wed, 25 May, 2016 at 4:33 PM
How to change all MySQL database table collation
After change the collation of a database, only the new tables will be created with the new collation. To change all the database collation, you can use th...
Thu, 26 May, 2016 at 11:55 AM
How to change MySQL Database password in cPanel
Below guideline will show you how to change Database password in cPanel   1) Login to your control panel domainname.com/cpanel or domainname.com:208...
Thu, 26 May, 2016 at 11:56 AM
How to delete MySQL database in cPanel
This guide is for Linux hosting cPanel users who want to delete their MySQL databases which no longer needed.   1. Enter your cPanel 2. Click on...
Mon, 13 Jun, 2016 at 3:17 PM
How to delete MySQL database in WebsitePanel
This guide is for Windows hosting WebsitePanel users who want to delete their MySQL databases which no longer needed. 1. Enter your WebsitePanel 2. Cl...
Thu, 26 May, 2016 at 11:57 AM