MX on Linux: Difference between revisions

MX on Linux (view source)

949 bytes removed , 11:01, 3 September 2020

m

5,838

edits

@@ Line 384: / Line 384: @@
 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.
-===Transferring database tables to your Pi===
-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 '''Cumulus 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 Cumulus table on your Pi.
-You might want to also '''export/import the PhpMyAdmin tables''' with your preferences in a separate zip, although these might need some extra transformations, as they are specific to a particular version of the database server (and the old device version may not match the MariaDB version on your Pi). Some PhpMyAdmin tables do change for different versions of the tool, so that too may make export/import of its tables more complicated.
 == Making your database secure ==