MX on Linux: Difference between revisions

Since MySQL database is controlled by Oracle, Maria is an alternative that has largely similar command syntax so is likely to work with code (like MX) designed to work with MySQL. Since the MX developer (Mark Crossley) actually uses Maria DB we can have plenty of confidence it is suitable.  To install it we type <tt>sudo apt install mariadb-server php-mysql -y</tt>.

Our database files will be stored at '''/var/lib/mysql''' by default. Our MariaDB configuration is stored at '''/etc/mysql/mariadb.conf.d/50-server.cnf''', and it is the ''datadir='' entry that controls where the database files are stored.  If you have been using Cumulus before and have a database then you can use PhpMyAdmin on your old device to '''export''' out all the tables as SQL in a zip file, FTP that zip file across to your Pi, use PhpMyAdmin to '''import''' that zip file.  Providing you selected the right options for what SQL you created in your export, the import will contain SQL to create the tables and to insert all the rows into each table.