User Tools

Site Tools


downgrade_sql_server

This is an old revision of the document!


How to downgrade MySQL|MariaDB to an older version

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

To downgrade to an older MySQL|MariaDB server version you must in order:

  1. Backup your current /var/lib/mysql directory
  2. Stop your MySQL|MariaDB server
  3. Remove any Debian flag file (rm /var/lib/mysql/debian-*)
  4. Remove the InnoDB log files* (rm ib_logfile*)

* Only needed in some cases (eg. when downgrading from MariaDB 10)

Once the steps above are done, you can run the i-MSCP installer as follow

# perl imscp-autoinstall -dar sql

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.1390844256.txt.gz · Last modified: 2014/01/27 17:37 by nuxwin