Search our database

Archive | MySQL RSS feed for this section
Viewing 21 to 28 of 28 items

How to solve MySQL error “Headers and client library minor version mismatch” (DirectAdmin platform)

In case when MySQL has been updated and PHP has been rebuild through custombuild but the websites are still showing this error: Warning: mysql_connect() [function.mysql-connect]: /Headers and client library minor version mismatch/. /Headers:50157 Library:50511/ Perform a cleanup in custombuild and rebuild PHP cd /usr/local/DirectAdmin/custombuild ./build clean ./build php n

How to solve MySQL error “Mysql has gone away”

Below is the steps you should perform to solve “Mysql has gone away” error: Step 1: Disable heavy plugins of your website – You can try disable the most recent install plugins first and monitor your website load, if same things happened, you may try disable the plugins 1 by 1

How to repair MySQL database in DirectAdmin

When you cannot access your website and you are seeing this kind of message: SQL query:   DELETE FROM sessions WHERE expiry <1349879630   MySQL said:   #126 – Incorrect key file for table ‘./your_database/sessions.MYI’; try to repair it It is possible that the hosting server had crashed and rebooted. After the server has restarted, […]

MySQL ConnectionString in ASP and ASP.Net:

Dim MyConString As String = _ "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & Server _ & ";DATABASE=" & DataBase & ";UID=" & User _ & ";PASSWORD=" & Password & ";OPTION=3;" Dim MyConString As String = _ "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & Server _ & ";DATABASE=" & DataBase & ";UID=" & User _ & ";PASSWORD=" & Password & […]

MySQL remote connection for Windows Shared Hosting:

Remote access to MySQL database on Windows Shared Hosting is enabled by default, simply use SQLyog available at http://code.google.com/p/sqlyog/downloads/list:1. Install and run SQLyog2. Click on New…3. Enter the following info:Host Address: yourdomain.com Username: DatabaseUser Password: DatabaseUserPassword Port: 3306 Database: DatabaseName4. Click on connect