MariaDB: Difference between revisions
m A few more MySQL's missed, website changed |
m Added MariaDB 10 upgrade section |
||
| Line 31: | Line 31: | ||
<div style="background:#FFEEEE;border:1px solid #FF0000;"> | <div style="background:#FFEEEE;border:1px solid #FF0000;"> | ||
'''MariaDB does not use the InnoDB storage engine by default. If you are using MariaDB with standard settings, these settings will have no effect and so don't need to be | '''MariaDB does not use the InnoDB storage engine by default. If you are using MariaDB with standard settings, these settings will have no effect and so don't need to be changed.''' | ||
</div> | </div> | ||
| Line 114: | Line 114: | ||
<pre>mysql> FLUSH PRIVILEGES;</pre> | <pre>mysql> FLUSH PRIVILEGES;</pre> | ||
* You can now exit the MariaDB server. | * You can now exit the MariaDB server. | ||
== Upgrading to MariaDB 10 == | |||
In openSUSE 13.1, it is possible to update to MariaDB 10 via. the repositories system. If you do decide to upgrade, MariaDB will not run straight away after installation. To make it run, follow these steps: | |||
# Make sure all databases are backed up (on this server, make sure your nightly backups have exported successfully) | |||
# Run <code>touch /var/lib/mysql/.force_upgrade</code> - this allows the upgrade to take place | |||
# Run <code>service mysql start</code> - this may take a while the first time it is started as the database is being upgraded | |||
== Related Articles == | == Related Articles == | ||