7

May/18

Cannot load from mysql.proc. The table is probably corrupted

I was trying to update accounts in MySQL and got the following error message: Cannot load from mysql.proc. The table is probably corrupted A little bit scary if my data was corrupted. Turns out there is an upgrade command which … Continue reading

5

Dec/16

Post MySQL Install

After installing MySQL you can run the below command to secure your install: sudo mysql_secure_installation The script will ask a bunch of questions and act accordingly so it is only as secure as you want it to be but it … Continue reading

18

Jun/16

Ubuntu 16.04 Migration Update

A quick update to my migration process. I had all the servers running 16.04 and it was OK except for the stability. Setting up and moving things were simple enough. I did encounter issues with my symlinked .bashrc which I … Continue reading

23

Nov/15

MySQL Workbench Error Code 7

Overview On Windows, I was getting the following error trying to take a database dump to file: mysqldump: [ERROR] unknown variable ‘delayed-insert=FALSE’ Operation failed with exitcode 7 At the time I was using Workbench 6.3.5. Temporary Fix Edit the file … Continue reading

29

Sep/14

MySQL Server 5.6 512MB RAM

Overview Ubuntu 14.04 added MySQL 5.6 to the official repository but it turns out installing it on anything less than 1GB RAM is pretty difficult. Disable Service Startup It is necessary to disable service startup after an install to prevent … Continue reading

14

Apr/14

TTRSS – Your access level is insufficient to run this script

After upgrading from 1.9 to 1.11 I had got the error message “Your access level is insufficient to run this script” when trying to log in. The problem was TTRSS needed to run some upgrade script but if you log … Continue reading

31

Mar/14

Move / Change Password RasPBX Database

Overview Migrating Host First export and import the database data into the new database. It goes without saying that the RasPBX should be stopped or any changes between the export and import will not be captured and lost. The root … Continue reading

2

Dec/13

Install Sonar 3.5.1 With MySQL On Tomcat 7 Running Ubuntu 13.04

Overview This post assumes MySQL is already installed. Create an empty schema for Sonar and a user with create, update, index, and delete like privileges. Tomcat 7 sudo apt-get install tomcat7 Java sudo apt-get install default-jdk Sonar Download and extract … Continue reading