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…)

Full backup Full backup is process of backing up ALL data. First step towards all other types of backup Backup time will be longer Restore operation takes less time Differential backup Differential backup is the process of backing up data that has changed since the last FULL backup. Requires file maintenance as the backup file will be of similar size or larger than its previous backup Longer backup time than incremental backup Faster restoration than incremental backup Incremental backup Incremental backup is the process of backing up data that has changed since the last Full, Incremental or Differential backup Takes lesser backup time as it will have small data to archive Takes longer restoration time Mirror backup Mirror backup is similar to full backup and is a direct copy of the files/folders Files are not compressed in zip files and are not protected with password. They remain the mirror or exact copy of the source.

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…)

$ sudo apt-get install phpmyadmin For versions 7.10 and up, choose "Apache 2" from the screen "Configuring phpmyadmin" If everything goes fine, you can access phpmyadmin from http://servername/phpmyadmin If you have created users in MySQL, you can use those credentials to log into the database. The basic admin account is "admin" with no password. Phpmyadmin defaults to requiring you to login after 1800 seconds of inactivity. » MySQL Create User, Grant Rights http://kurinchilamp.kurinchilion.com/2009/04/mysql-create-user-grant-rights.html

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.