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 > dumb...
Thu, 4 Mar, 2021 at 1:15 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. ...
Thu, 4 Mar, 2021 at 1:16 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 table. ...
Thu, 4 Mar, 2021 at 1:17 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 ...
Thu, 4 Mar, 2021 at 1:19 AM
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 (li...
Thu, 4 Mar, 2021 at 1:20 AM
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 the...
Thu, 4 Mar, 2021 at 1:25 AM
How to optimize your MySQL databases
Databases is one of the important entities for the website to work normally. There is also some times that the required database may some times take up to m...
Thu, 4 Mar, 2021 at 1:26 AM
MySQL syntax error when installing older application.
If you receive below error when you install older application, Example:  "Failed to create faq table: You have an error in your SQL syntax; check t...
Thu, 4 Mar, 2021 at 1:27 AM
What is the port does MySQL use?
We have never change the MySQL port and the port is still uses back the default port.  Our MySQL uses Port 3306 where you could connect through MySQL Admin...
Thu, 4 Mar, 2021 at 1:28 AM
Remote connect MySQL databases via MySQL Workbench
One tool you can use to connect to remotely connect to databases on your shared, VPS, or Dedicated hosting account is MySQL Workbench. MySQL Workbench is a ...
Thu, 4 Mar, 2021 at 1:13 AM