Archive for 'MySQL'

MySQL table corrupt & repair

Recently I am trying to dump a customer MySQL database to a SQL file & restore to another server. An error occur during the dump process. The error mention that one of the table in the database is crashed & repair required. Then I try to login into MySQL server & use the particular database […]

MySQL server has gone away

Today I am trying to restore one of MySQL dump into my development database. While I executing the mysql -uroot -p XXXX < XXXX.sql, the restoration show me the error of “ERROR 2006 (HY000) at line 3051: MySQL server has gone away“. Then I double check on the database that I restore, I found that the […]

How to reset MySQL root password

As a database administrator, you might forget the root password for your database. It is a serious problem. This tutorial is to teach you how to reset the root password if you forget it. (more…)