5,838
edits
MX on Linux: Difference between revisions
m
→Installing Adminer, PhpLiteAdmin, or PhpMyAdmin
| Line 313: | Line 313: | ||
Cumulus MX includes two SQLite databases, one is the [[Weather Diary]], the other's use is not documented (see [[Cumulusmx.db]]). You might want to install phpLiteAdmin (the significant part of that name is in the middle) to read those SQLite databases using <tt>sudo apt install phpliteadmin</tt>. | Cumulus MX includes two SQLite databases, one is the [[Weather Diary]], the other's use is not documented (see [[Cumulusmx.db]]). You might want to install phpLiteAdmin (the significant part of that name is in the middle) to read those SQLite databases using <tt>sudo apt install phpliteadmin</tt>. | ||
ExportMySQL.exe and CumulusMX.exe (see [[Cumulus_MX#Executables]] for details) both create SQL for updating tables in a MySQL database, such as the one our MariaDB software package we have installed can create; so maybe we want to install a package that lets us back up and manipulate tables in this database. PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps '''adminer''' that works using a drill down approach. However, let me assume that you are happy to use PHPMyAdmin and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>. (Alternatively install a drill down package with <tt>sudo apt install adminer</tt> and I leave you to work out the commands needed after that). | ExportMySQL.exe and CumulusMX.exe (see [[Cumulus_MX#Executables]] for details) both create SQL for updating tables in a MySQL database, such as the one our MariaDB software package we have installed can create; so maybe we want to install a package that lets us back up and manipulate tables in this database. PHPMyAdmin is not the only tool that can be used to manipulate your MySQL like database (that is the significance of the "My" bit in the middle of the tools's name), and you may prefer to load a different tool, perhaps '''adminer''' that works using a drill down approach. However, let me assume that you are happy to use '''PHPMyAdmin''' and I will describe how to install that. Start the install with <tt>sudo apt install phpmyadmin -y</tt>. (Alternatively install a drill down package with <tt>sudo apt install adminer</tt> and I leave you to work out the commands needed after that). | ||
The PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. | The PhpMyAdmin installer will ask some questions. Use your tab key to select <Yes> when it asks whether you want to configure with '''dbconfig-common'''. | ||