E REINSTALLATION OF MYSQL
-
Login with root user.
-
Run the below command and grep the package name for installed mysql :
rpm -qa | grep –i mysql -
Check the version details of mysql package:
rpm -qa | grep –i mysql -
Remove mysql package:
rpm -qa|grep -i MySQL|xargs rpm --nodeps --erase -
Run step 2 again to confirm that the package is removed and then proceed further.
-
Run the following commands to clean the database directory. This command should be run only if it is required to delete the MySQL database, due to some inconsistency or corruption in the database.
rm –rf /usr/mysql/mysql1/* -
Proceed with fresh install of QS as mentioned in 5.1.
-
Once the above procedure is completed, execute steps 1, 2 and 4 to 7 of the Start/Stop Replication Procedure.