MySQL Backup

MySQL InnoDB Corruption Repair Guide

MySQL InnoDB Corruption Repair Guide
This is a basic guide that goes over some of the methods you can use to deal with some of the most common InnoDB corruption issues, from start to finish.

SECTIONS

/A/ First Response
A/1 Initial Steps​
A/2 If MySQL is Crashing

/B/ Identifying the Problem
B/1 Examining the Logs​

B/1.1 Page Corruption​

B/1.2 …Read More

Installing Lighttpd with PHP (PHP-FPM mode) and MySQL or MariaDB on Ubuntu 15.04

Installing Lighttpd with PHP (PHP-FPM mode) and MySQL or MariaDB on Ubuntu 15.04

Installing Lighttpd with PHP (PHP-FPM mode) and MySQL or MariaDB on Ubuntu 15.04
Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an Ubuntu 15.04 server with PHP support (through PHP-FPM) and MySQL. PHP-FPM (FastCGI Process Manager) is an …Read More

MySQL Backup

Upgrading MySQL databases after a software update

Upgrading MySQL databases after a software update (and possibly repairing structure and tables if problems occurs)

 

Sometimes MySQL changes its internal database structures between versions. When that is the case, you might get these kind of errors after updating it (probably via yum) and trying to start it:
[ERROR] Missing system table …Read More

LAMP Server (Apache / MariaDB /PHP) on Fedora 19+ and Centos/RHEL 7

LAMP Server (Apache / MariaDB /PHP) on Fedora 19+ and Centos/RHEL 7

LAMP is a combination of operating system and open-source software stack. The acronym LAMP comes from the first letters of Linux, Apache HTTP Server, MySQL/MariaDB database, and PHP, Perl or Python (and sometimes PhpMyAdmin too.)

 
Installing Apache
Change to root (if not root already) user using the following command:

and install apache using …Read More

How to Fix MySQL Database (MyISAM / InnoDB)

How to Fix MySQL Database (MyISAM / InnoDB)

So… your shiny MySQL database is no longer running and you want to fix it?

You’ve come to the right place!

I’ve assembled a list of 7 ways to fix your MySQL database when a simple restart doesn’t do the trick, or when you have corrupt tables.

Simple MySQL restart:

/usr/local/mysql/bin/mysqladmin -uUSERNAME -pPASSWORD shutdown
/usr/local/mysql/bin/mysqld_safe …Read More

CentOS and RHEL 7: Install Linux, Apache, MariaDB, PHP (LAMP)

Install LAMP Server (Apache, MySQL or MariaDB, PHP) On Ubuntu 14.10/14.04/13.10

LAMP is a combination of operating system and open-source software stack. The acronym LAMP comes from the first letters of Linux, Apache HTTP Server, MySQL or MariaDB database, and PHP/Perl/Python.

In this tutorial, we will see how to setup LAMP server on Ubuntu 14.10 system.
Install Apache
Apache is an open-source multi-platform web …Read More