downgrade_sql_server
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
downgrade_sql_server [2014/01/27 17:04] nuxwin created |
downgrade_sql_server [2014/01/30 10:11] (current) nuxwin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Howto Downgrade MySQL|MariaDB to an older version ====== | + | ====== How to downgrade MySQL|MariaDB to an older version ====== |
| ===== Preliminary considerations ===== | ===== Preliminary considerations ===== | ||
| - | Downgrading your MySQL|MariaDB server to an older version is not always a good thing, specially if you or your customers used some features which are not available in the version to which you want downgrade. Therefore, This action must be carefully considered. | + | Downgrading your MySQL|MariaDB server to an older version is not always a good thing, specially if you or your customers used some features which are not available in the version to which you want downgrade. Therefore, this action must be carefully considered. |
| ==== Downgrading ==== | ==== Downgrading ==== | ||
| Line 10: | Line 10: | ||
| - Backup your current /var/lib/mysql directory | - Backup your current /var/lib/mysql directory | ||
| + | - Execute the following SQL query (SET GLOBAL innodb_fast_shutdown = 0;) | ||
| - Stop your MySQL|MariaDB server | - Stop your MySQL|MariaDB server | ||
| - | - Remove any Debian flag files (//rm /var/lib/mysql/debian-*//) | + | - Remove any Debian flag file (//rm /var/lib/mysql/debian-*//) |
| - Remove the InnoDB log files* (//rm ib_logfile*//) | - Remove the InnoDB log files* (//rm ib_logfile*//) | ||
| Line 20: | Line 21: | ||
| # perl imscp-autoinstall -dar sql | # perl imscp-autoinstall -dar sql | ||
| - | and choose the MySQL|MariaDB version to which you want downgrade. | + | and choose the MySQL|MariaDB server version to which you want downgrade. |
/var/www/virtual/i-mscp.net/wiki/htdocs/data/attic/downgrade_sql_server.1390842274.txt.gz · Last modified: 2014/01/27 17:04 by nuxwin
