How To Fix Corrupted Tables in MySQL

Occasionally, MySQL tables can become corrupted, meaning that an error has occurred and the data held within them is unreadable. Attempts to read from a corrupted table will usually lead to the server crashing. Some common causes of corrupted tables are: The MySQL server stops in middle of a write. An external program modifies a…

How To Troubleshoot Socket Errors in MySQL

MySQL manages connections to the database server through the use of a socket file, a special kind of file that facilitates communications between different processes. The MySQL server’s socket file is named mysqld.sock and on Ubuntu systems it’s usually stored in the /var/run/mysqld/ directory. This file is created by the MySQL service automatically. Sometimes, changes…

Como Gerenciar um Banco de Dados SQL

Um Guia de Consulta Rápida SQL Introdução Os bancos de dados SQL vêm instalados com todos os comandos necessários para adicionar, modificar, excluir e consultar seus dados. Este guia de consulta rápida fornece uma referência para alguns dos comandos SQL mais usados. Como Utilizar Este Guia: Este guia está no formato de consulta rápida com…

How to Manage an SQL Database

Introduction SQL databases come installed with all the commands you need to add, modify, delete, and query your data. This cheat sheet-style guide provides a quick reference to some of the most commonly-used SQL commands. How to Use This Guide: This guide is in cheat sheet format with self-contained command-line snippets Jump to any section…

How To Install Java with Apt on Debian 9

Introduction Java and the JVM (Java’s virtual machine) are required for many kinds of software, including Tomcat, Jetty, Glassfish, Cassandra and Jenkins. In this guide, you will install various versions of the Java Runtime Environment (JRE) and the Java Developer Kit (JDK) using apt . You’ll install OpenJDK as well as official packages from Oracle.…