Bash Script to Check, Repair, Optimise and Backup MySQL database
I have a VPS (Virtual Private Server) and I have just move another domain (steakovercooked.com) onto this. I find it useful to have a script that can automatically check, …
Category: MySQL
How to Fix MySQL Crash due to OOM Error?
August 23, 2014
apache server, database, DevOps, MySQL, mysql, tricks, Virtual Private Server, webhosting
No Comments
MySQL server stopped due of out of memory exception on Ubuntu VPS As you may know, my three websites are hosted on a VPS starter package from QuickHostUK – …
Database Optimisation Script in PHP
Well, sometimes, you probably need to optimise your MySQL tables. In order to avoid the hassle loggin to your remote SSH server, you probably want to write a script …