In this blog post, I’ve summarized the table maintenance tasks in MySQL. I’ve outline what each does and its syntax.
Cheers!
No comments
Tag: MySQL
MySQL – Solution to Dependency Issues During MySQL Installation Using RPM
For complete steps on how to install MySQL 5.7 on Redhat, you may refer to this link
In this blog, I will show you specifically how simple it is to resolve the dependency issues that you might encounter while installing MySQL 5.7 on RedHat 6 using RPM.
Below are the dependency errors I encountered during installation.
The solution is simple. Just put the option –nodep at the end of the rpm command.
# rpm -ivh mysql-commercial-embedded-devel-5.7.21-1.1.el6.x86_64.rpm --nodeps
That’s it.
Cheers
MySQL – Database Patch Upgrade on Windows Step-by-Step with Screenshots
1. Download the latest patch for MySQL in My Oracle Support. I choose MySQL installer for the integrated installer for windows.
1.1. Go to Patches & Updates. Chooose Product or Family (Advanced). Type MySQL Server on Products. Expand the options in the Release drop down and choose your desired release. Choose Microsoft Windows x64 in Platform option.
1.2. Choose the latest patch.
1.3. Click Download
2. Verify the current version
3. Backup databases
4. Double click on the patch
5. Click Next >
6. I will choose to upgrade all components. Click Next >
7. Click Execute.
8. Click Next >
9. Click Next >
10. Enter root password then click Check. If the connection succeeded, Click Next >
11. Click Execute
12. Click Finish
13. Verify new MySQL version. Click Next >
14. Click Finish
This is how I upgrade the patch of our MySQL database on windows. Just be sure to backup your databases and/or if your server is a VM, ask your Windows Admin team to perform a VM snapshot of the server before you apply the patch.
Cheers!