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 […]
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 […]
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…)
If you enjoyed the post, make sure you subscribe to the RSS feed.
© 2024
Powered by WordPress. Design by 
Recent Comments