{"id":949,"date":"2017-01-23T12:11:15","date_gmt":"2017-01-23T17:11:15","guid":{"rendered":"http:\/\/easy-admin.ca\/?p=949"},"modified":"2017-08-21T10:10:38","modified_gmt":"2017-08-21T14:10:38","slug":"recovering-from-a-disaster-when-upgrating-mysql-on-virtualmin","status":"publish","type":"post","link":"https:\/\/easy-admin.ca\/index.php\/2017\/01\/23\/recovering-from-a-disaster-when-upgrating-mysql-on-virtualmin\/","title":{"rendered":"Recovering from a disaster when upgrading PHP-MySQL on VirtualMIN"},"content":{"rendered":"<h4>YUM Downgrade syntax for\u00a0 CentOS\/RHEL 6.x\/7.x+ users<\/h4>\n<p>The syntax is:<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"bash\"> ## get list ##\r\nyum history\r\n\u00a0\r\n## Okay undo\/downgrade it ##\r\nyum history undo {NUMBER-HERE}<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h3>BACKUP ALL YOUR VIRTUAL SVR BEFORE THIS!!!<br \/>\nALSO BAREBONE BACKUP YOUR ENTIRE SERVER IF POSSIBLE.<\/h3>\n<p>Apply only when you had updated via root the PHP-MySQL on,,.<br \/>\nwebmin \/ virtualmin.<\/p>\n<h3>Examples<\/h3>\n<p>For demo purpose, I\u2019m going to install\/update zsh:<br \/>\n<code>sudo yum install zsh<\/code><br \/>\nNow, list yum history:<br \/>\n<code>sudo yum history<br \/>\nsudo yum history list<br \/>\nsudo yum history info<\/code><br \/>\nSample outputs:<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"ini\">Loaded plugins: fastestmirror\r\nID     | Login user               | Date and time    | Action(s)      | Altered\r\n-------------------------------------------------------------------------------\r\n    11 |  &lt;veryv&gt;                 | 2015-05-05 11:14 | Update         |    1   \r\n    10 |  &lt;veryv&gt;                 | 2015-05-05 11:08 | Downgrade      |    1   \r\n     9 |  &lt;veryv&gt;                 | 2015-05-05 10:56 | Install        |    1   \r\n     8 |  &lt;veryv&gt;                 | 2015-05-05 10:56 | Install        |    1   \r\n     7 |  &lt;veryv&gt;                 | 2015-05-05 09:59 | Update         |    1   \r\n     6 | System &lt;unset&gt;           | 2015-04-23 20:02 | I, O, U        |  156 EE\r\n     5 | System &lt;unset&gt;           | 2015-04-23 20:02 | Install        |    1   \r\n     4 | System &lt;unset&gt;           | 2015-04-23 20:02 | Install        |    1 EE\r\n     3 | System &lt;unset&gt;           | 2015-04-23 20:02 | Install        |    1   \r\n     2 | System &lt;unset&gt;           | 2015-04-23 20:02 | Install        |    1   \r\n     1 | System &lt;unset&gt;           | 2015-04-23 20:00 | Install        |  280   \r\nhistory list<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Let us undo (downgrade) ID #11 (i.e. the last action of zsh update):<br \/>\n<code>sudo yum history undo 11<\/code><br \/>\nSample outputs:<\/p>\n<div class=\"wp_syntax\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"ini\">Loaded plugins: fastestmirror\r\nUndoing transaction 11, from Tue May  5 11:14:21 2015\r\n    Updated zsh-5.0.2-7.el7.x86_64     @base\r\n    Update      5.0.2-7.el7_1.1.x86_64 @updates\r\nLoading mirror speeds from cached hostfile\r\n * base: mirror.web-ster.com\r\n * extras: mirror.raystedman.net\r\n * updates: centos-distro.cavecreek.net\r\nResolving Dependencies\r\n--&gt; Running transaction check\r\n---&gt; Package zsh.x86_64 0:5.0.2-7.el7 will be a downgrade\r\n---&gt; Package zsh.x86_64 0:5.0.2-7.el7_1.1 will be erased\r\n--&gt; Finished Dependency Resolution\r\n\u00a0\r\nDependencies Resolved\r\n\u00a0\r\n===========================================================================================\r\n Package           Arch                 Version                   Repository          Size\r\n===========================================================================================\r\nDowngrading:\r\n zsh               x86_64               5.0.2-7.el7               base               2.4 M\r\n\u00a0\r\nTransaction Summary\r\n===========================================================================================\r\nDowngrade  1 Package\r\n\u00a0\r\nTotal download size: 2.4 M\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\nzsh-5.0.2-7.el7.x86_64.rpm                                          | 2.4 MB  00:00:02     \r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n  Installing : zsh-5.0.2-7.el7.x86_64                                                  1\/2 \r\n  Cleanup    : zsh-5.0.2-7.el7_1.1.x86_64                                              2\/2 \r\n  Verifying  : zsh-5.0.2-7.el7.x86_64                                                  1\/2 \r\n  Verifying  : zsh-5.0.2-7.el7_1.1.x86_64                                              2\/2 \r\n\u00a0\r\nRemoved:\r\n  zsh.x86_64 0:5.0.2-7.el7_1.1                                                             \r\n\u00a0\r\nInstalled:\r\n  zsh.x86_64 0:5.0.2-7.el7                                                                 \r\n\u00a0\r\nComplete!<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Verify zsh package history, enter:<br \/>\n<code>sudo yum history list zsh<\/code><br \/>\nSample outputs:<\/p>\n<pre>Loaded plugins: fastestmirror\r\nID     | Command line             | Date and time    | Action(s)      | Altered\r\n-------------------------------------------------------------------------------\r\n    12 | history undo 11          | 2015-05-05 11:19 | Downgrade      |    1   \r\n    11 | install zsh              | 2015-05-05 11:14 | Update         |    1   \r\n    10 | downgrade zsh            | 2015-05-05 11:08 | Downgrade      |    1   \r\n     8 | install zsh              | 2015-05-05 10:56 | Install        |    1   \r\nhistory lis<\/pre>\n<p><em>~ HAVE A GOOD TIME FIXING THIS!!!<\/em><\/p>\n<p><strong>Server is fixed! but lost some data!<\/strong><\/p>\n<p><em>Cheers!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>YUM Downgrade syntax for\u00a0 CentOS\/RHEL 6.x\/7.x+ users The syntax is: ## get list ## yum history \u00a0 ## Okay undo\/downgrade it ## yum history undo {NUMBER-HERE} BACKUP ALL YOUR VIRTUAL SVR BEFORE THIS!!! ALSO BAREBONE BACKUP YOUR ENTIRE SERVER IF POSSIBLE. Apply only when you had updated via root the PHP-MySQL on,,. webmin \/ virtualmin. &hellip; <a href=\"https:\/\/easy-admin.ca\/index.php\/2017\/01\/23\/recovering-from-a-disaster-when-upgrating-mysql-on-virtualmin\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Recovering from a disaster when upgrading PHP-MySQL on VirtualMIN<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":950,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/comments?post=949"}],"version-history":[{"count":0,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/media\/950"}],"wp:attachment":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/media?parent=949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/categories?post=949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/tags?post=949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}