![]() ![]() if it works it will be quick, if you can restore the manual directory backup then hardly any extra time, if it still isnt playing ball then obviously the most time consuming will be manually restoring account backups. This approach provides the least time depending on any resulting issues, ie. If you find that all databases are now missing, you will need to unpack the backup you made of the /var/lib/mysql/ directory, hopefully this should restore everything back to normal but if this fails then you will need to restore each account from the backups one by one. Now MySQL MariaDB will be re-installed based on the DB version set in WHM, finally from the MySQL/MariaDB Upgrade menu in WHM you should be able to upgrade to your preferred system and version. Yum remove MySQL55-client-5.5.86_64Īfter that remove the mysql pid file using the following command: rm -f /var/lib/mysql/*.pid Re-installing MySQL / MariaDB RPMsĪt last you need to install WHM / cPanel compatible database RPMs, this can be done using a single command: /scripts/check_cpanel_rpms –fix Below is an example, just remember to refer to the returned list above and call “yum remove x” where x is the string from each line returned above. Then remove the needed MySQL / MariaDB RPMs on the server using the yum command. For that issue the following command: rpm -qa | grep -i mysql Removing MySQL / MariaDB RPMsįirstly you need to know the MySQL / MariaDB RPMs that are installed on your server. Once you are confident you have a fall-back plan if all goes bad you can continue with the steps below to remove all MySQL / MariaDB packages and re-install them with WHM. ![]() I recommend you take backups from within WHM’s backup interface as well as taking a direct file dump of mysql’s databasedirectory which you can find at the location below: cd /var/lib/mysql/ Unfortunately re-installing your DB packages is no easy task and can easily escalate to a nightmare, sometimes even lead to a complete disaster! So make sure you take full backups of all accounts before you begin to expect the worst case scenario of starting with a completely fresh database with no users or tables. Obtained version information from system.įile /usr/share/man/man1/mysql_config.1.gz from install of MySQL55-devel-5.5.86_64 conflicts with file from package MariaDB-devel-5.5.86_64 at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 839. We expected to upgrade to 5.6 however, the system is currently on version 5.5. There are some cases where you need to completely re-install MySQL or MariaDB, whether it is because the package has corrupted or is having problems or if in our case with a client you have a non-standard service installed and you are getting messages such as: The cPanel & WHM Update Configuration File - cpupdate.How to re-install MySQL on a WHM/cPanel server More information is available in our documentation: Attempting to specify 92 or lower will fail. You can specify any available tier or version above 94. ![]() You will need to edit the line "CPANEL" and replace the value with your targeted version. Here is the file format for the contents of this file: CPANEL=release To install a specific version of cPanel & WHM, you must create the following file before installing cPanel: /etc/nf We only recommend installing the versions of cPanel that are available in a release tier as listed on our update servers. This will also enable you to install the "EDGE" experimental build of cPanel on a new system. Although this is not recommended, as we want for your server to run the most up-to-date version of cPanel, this is still possible. For some servers, you may require the installation of a specific version of cPanel & WHM. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |