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.
/A/ First Response
A/1 Initial Steps
A/2 If MySQL …Read More
How to Recover InnoDB MySQL Table Data from ibdata and .frm Files
This tutorial explains how to restore MySQL tables when all or some of the tables are lost, or when MySQL fails to load table data.
One of the reason for …Read More
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 …Read More
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 …Read More
Years ago, MySQL started allowing InnoDB to possess separate tablespace per table instead of a massive unified ibdata1 file. Tablespace is basically a logical storage area that contains table information – references, if you will. Every table, regardless of the storage …Read More
While automated backups are important, sometimes you just want to take a quick and dirty MySQL Backup of a database or all databases before making a change to your data. When changing files in Linux, you can simply cp a file …Read More
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.)
Change to root (if not …Read More
I have a Database having number of tables.
I want to delete some records from the tables say the no of records are more than 20K or 50K.
The All the Tables are InnoDB. And file_per_table is off.
When I will delete the …Read More
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 …Read More
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 …Read More
Author: Falko Timme <ft [at] falkotimme [dot] com>
Last edited 08/28/2008
MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That …Read More
Why should I migrate from MySQL to MariaDB?
MariaDb is an enhanced drop-in replacement and community-developed fork of the MySQL database system. It was developed by MariaDB foundation, and is being led by original developers of MySQL. Working with MariaDB is …Read More