Flushing the ibdata1 file, when MariaDB steals disk space.

PLEASE NOTE THAT THIS ASSUMES THAT YOU ARE RUNNING ONLY JAYFISH ON YOUR MARIADB/pi instance … and that you DO NOT HAVE ANY CUSTOM DB’s running alongside Jayfish.  If your install is STOCK and only runs Jayfish … your good … if not … my script does NOT know about...

Dosing with Jayfish (Upgrade instructions included.)

UPGRADE INSTRUCTIONS You would follow these instructions if you are already running JayFish without Dosing and you would like to upgrade without replacing your entire database.  This is how. The setup has been upgraded you need to update your installer files.  To do...

With Stretch : MariaDB SQL Remote Access – HOW

Ok, since Raspian Stretch upgraded to using MariaDB instead ot MySQL by default, they have removed the setting up of the root account by default during setup, in JESSIE with MySQL they allowed you to specify the password.  When installing the MariaDB that step is...

Setup Files – Purposes and Descriptions

Install Script Descriptions These scripts are downloaded after you execute base-setup.sh, this will help you understand what they are for and their use. backup.sh – Running this script will backup the your website and database to a safe location before running...

Site navigation descriptions and purposes.

Dashboard The purpose of the dashboard is to give you a heads up on all the critical things, a quick visual area to be able to see whats happening. Key Dashboard Areas Are Phases of the day and which Phase your Raspberry Pi is in. Water Change (days) Allows you to log...

Backing up your database before an update.

From time to time I release updates, since we don’t have a formal QA crowd, sometimes something might go wrong.  No matter how much it’s tested. I have written a script that will manage your backup and restore procedure.  IT BACKS UP YOUR DATABASE AND YOUR...