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 > dum...
Mon, 6 Apr, 2020 at 11:49 AM
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. ...
Mon, 6 Apr, 2020 at 11:53 AM
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 ...
Mon, 6 Apr, 2020 at 3:03 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 (l...
Mon, 6 Apr, 2020 at 4:26 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 your...
Mon, 24 Feb, 2020 at 12:08 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...
Tue, 7 Apr, 2020 at 11:46 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:2082 ...
Mon, 24 Feb, 2020 at 1:38 PM
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 MySQL D...
Mon, 24 Feb, 2020 at 1:40 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. Clic...
Mon, 24 Feb, 2020 at 1:46 PM