When new fileds are created as variable characters they get stored as latin1_swedish_ci as default. To change the default collation users will have to manually select the collation of their choice from the mysql admin interface such as in the case of phpmyadmin or will have to denote it in sql queries. To make a specific collation as the default, other option to give mysql an indication of it by having the needed collation name in my.cnf (mysql configuration) as shown below Edit my.cnf: [mysqld] collation_server=latin1_general_ci (more…)

Reason for the error is the availability of space allocated to the MySQL database in the specified partition. Easy fix for this is to go to the PhpMyAdmin interface (via CPanel/WHM) and identify the tables which has some value in under overhead column. Select ALL those tables and choose the option "Repair table" after you ensure that there is enough space in the database.

HeidiSQL - a comprehensive tool for MySQL management which is available for Free. Manage data tables, export/import databases, synchronise tables between databases, integrity check, database backup service management, edit database content and many more features packaged as a solution for ALL your MySQL needs. This runs on windows platforms - WinXP/XP7 and you can download HeidiSQL from Download link (more…)

When moving mysql database from one server to another or, to test that the data backup works as expected we need to import mysql dump file in the testing environment. Create the database (test-database) in the testing environment and identify the location of the .gz or .sql file. If the mysql dump was a .gz file, you need to gunzip to uncompress the file by typing $ gunzip mysqldump.sql.gz This will uncompress the .gz file and will just store mysqldump.sql in the same location. (more…)

To clear the screen content in MySQL use the command mysql> \! clear Usage of "\!" tells MySQL to pass the command to Linux OS to handle the request. If you are in a Windows environment (DOS prompt), to pass the control to the OS you can use the command mysql>system cls

Reason why this error might occur: i) Incomplete MySQL implementation ii) MySQL setting mis-configuration Solution: root@myserver:/# vi /etc/mysql/my.cnf Comment out the below line in my.cnf file to make MySQL listen on ALL interfaces #bind-address = 127.0.0.1 root@myserver:/# netstat -tap | grep mysql tcp 0 0 *:mysql *:* LISTEN 17785/mysqld Note that above line which indicates MySQL listening on all interfaces.