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