User Tools

Site Tools


downgrade_sql_server

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
downgrade_sql_server [2014/01/27 17:37]
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 file (//rm /​var/​lib/​mysql/​debian-*//​)   - Remove any Debian flag file (//rm /​var/​lib/​mysql/​debian-*//​)
/var/www/virtual/i-mscp.net/wiki/htdocs/data/attic/downgrade_sql_server.1390844256.txt.gz · Last modified: 2014/01/27 17:37 by nuxwin