Database Server

[How To] Enable MySQL Event Scheduler status

mysql logo

The event scheduler in MySQL needs to be enabled for some applications to work flawlessly. In this case, a small change is required in the MySQL configuration file my.cnf. Steps: 1. Open my.cnf file in your favourite editor vi /etc/my.cnf 2. Add following line event_scheduler=on This will enable MySQL event scheduler on the server. 3. Restart MySQL service /etc/init.d/mysql restart …

Read More »

MySQL Got error 28 from storage engine [Resolved]

mysql logo

The MySQL database backup can be taken using mysqldump command from command line in a Linux server. Sometimes, the following error may occur while taking database backup "'Got error 28 from storage engine' when trying to dump tablespaces" Though the error does not provide much information, the issue is related with the disk space on the server. In this case …

Read More »

[How To] Reset MySQL root password

mysql logo

MySQL root password is important if you want to access phpMyAdmin, secure MySQL command prompt access, etc. In case one forgets the MySQL root password or wants to set root password, following steps should help to achieve the same. 1) Stop the MySQL Server: /etc/init.d/mysql stop or /etc/init.d/mysqld stop 2) Start the MySQL configuration: mysqld --skip-grant-tables & or mysqld_safe --skip-grant-tables …

Read More »

MySQL replication problem: ‘show master status’ shows ‘Empty set (0.00 sec)’

mysql logo

In MySQL replication, you setup master and slave MySQL server. On master server, while checking the master status, you might end up with following error message: 1 2 3 4 mysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary logging The MySQL error log will not provide any help …

Read More »