Blog ยป MySQL

MySQL

Disable MySQL strict mode

Many third party scripts viz. Cubecart, WHMCS etc. require to disable MySQL strict mode. If you do not disable MySQL strict mode, you may receive errors during installation. The most commons errors are as follow: To disable MySQL strict mode, you will need your server’s root or administrative access. You will need to edit “sql-mode” …

Disable MySQL strict mode Read More »

Large MySQL Bin files – High disk usage by MySQL Bin files

You may have seen “server-bin.n” or “mysql-bin.00000n” (n represent num0der) under your MySQL directory (/var/lib/mysql). These files are binary logs for MySQL. The binary log contains all statements that update data. It also contains information about how long each statement took that updated data. MySQL binary logs are used for data recovery and replication. How …

Large MySQL Bin files – High disk usage by MySQL Bin files Read More »

MySQL server has gone away – MySQL restore error

You may receive the following error while restoring your MySQL database: ERROR 2006 (HY000) at line xxx: MySQL server has gone away In most cases this error occurs due to max_allowed_packet limit. The default limit for max_allowed_packet is 1 MB which is not sufficient. If it requires more packet size during the restore, you will …

MySQL server has gone away – MySQL restore error Read More »

How to completely remove MySQL from Windows system

How to completely remove MySQL from Windows system Whenever you uninstall MySQL server from “Add/Remove Programs”, only the installed components are removed. The database information (including the tables and data), import or export files, log files, and binary logs produced during execution are kept in their configured location. You may experience problem reinstalling MySQL server …

How to completely remove MySQL from Windows system Read More »