This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
downgrade_sql_server [2014/01/27 17:05] nuxwin |
downgrade_sql_server [2014/01/30 10:11] (current) nuxwin |
||
---|---|---|---|
Line 3: | Line 3: | ||
===== 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. |