MySQL
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 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
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
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
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
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
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
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
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
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