MX on Linux: Difference between revisions

3 bytes removed ,  21:18, 2 September 2020
m
m (→‎Adding a web server: cut and paste)
Line 386: Line 386:


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 table. 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.
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 table. 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.
== Restarting Apache ==
After all these installs, we need to restart Apache (so it loads the PHP and MariaDB), by typing <tt>sudo service apache2 restart</tt>.
WE will also need to do this any time we change our php.ini files, database passwords, and anything else that is checked when the web server starts.


== Making your database secure ==
== Making your database secure ==
Line 422: Line 416:


You can view any index.php or PHPMyAdmin web page in your browser by prefixing the address with your Pi URL e.g. '''http://192.168.1.xy/phpmyadmin''' where x and y are digits you look up as mentioned before where FTP of MX distribution was described. In this case you will see a PHP MyAdmin log on page where you type username and password (as you may not have added any other user yet, the user will be root).
You can view any index.php or PHPMyAdmin web page in your browser by prefixing the address with your Pi URL e.g. '''http://192.168.1.xy/phpmyadmin''' where x and y are digits you look up as mentioned before where FTP of MX distribution was described. In this case you will see a PHP MyAdmin log on page where you type username and password (as you may not have added any other user yet, the user will be root).
== Restarting Apache ==
After all these installs, we need to restart Apache (so it loads the PHP and MariaDB), by typing <tt>sudo service apache2 restart</tt>.
We will need to do this any time we change our php.ini files, database passwords, and anything else that is checked when the web server starts.
5,838

edits