How to export/import a MySQL database via SSH
If you have a large database, you may face the issue to export/import large SQL database using phpMyAdmin or other interface. In this article we will show you how to…
0 Comments
July 26, 2015
Check MySQL service uptime through command line
Check MySQL service uptime through command line As a server administrator, it is easy to check MySQL service uptime through command line (via SSH for Linux server or MySQL command…
April 4, 2014
Disable MySQL strict mode
Many third party scripts viz. Cubecart, WHMCS etc. require to disable MySQL strict mode. If MySQL strict mode is not disabled in MySQL server, you may receive the errors during…
January 8, 2014
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…
October 11, 2013
MySQL error #1036 – Table is read only
You may receive the following error while repairing or optimizing the MySQL tables: #1036 - Table 'xyz' is read only When the MySQL tables are in "read only" status, you…
September 30, 2013
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…
June 11, 2013
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),…
September 1, 2012