MariaDB Index column size too large
While restoring the database we are receiving the following error ERROR 1709 (HY000) at line 15: Index column size too large. The maximum column size […]
MySql
Backup of mysql database using cron job.
To generate the backup of mysql database using cron job refer following three format as per your requirement. 1) Cron job to generate database backup […]
mysql has failed, please contact the sysadmin (result was “mysql has failed”).
Now a most common problem we are facing with the mysql on newly installed server if we have mysql 5 we mostly receive following error […]
Simple command to check mysql max_connections limit
On the dedicated server or VPS server many time, we face the server load issue because of excessive connection to the MySQL database, to resolve […]
Simple php script to check database connection?
To check the database connection script you can use following code under your domain <?php mysql_connect(“localhost”, “admin”, “1admin”) or die(mysql_error()); echo “Connected to MySQL<br />”; […]