When you need to migrate a MySQL server instance to a new server for any reason, eg upgrade of hardware, distri upgrade,… you can easily do the following: Migrating the databases On the “old” mysql server, you need to export all databases by: mysqldump -uroot -p –all-databases > /tmp/dumpofalldb.sql Copy your sql dump file with […]
Migrating MySQL to a new server Read More »
Recently I had some problems with a Sphinx search server which was upgraded through apt-get update && apt-get upgrade This caused the Sphinx Storage engine inside my MySQL server fail to work. When doing a search inside Mysql, eg by: select * from dbname.content_index; I got the follwoing error: Error Code: 1286. Unknown table engine
Install MySQL with Sphinx Search Engine support Read More »
I you forgot your MySQL root password, you can recover MySQL database server password with following five easy steps. Stop the MySQL server process. Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password. Connect to mysql server as the root user. Setup new mysql root account password i.e.
Forgot MySQL root password Read More »