MySQL Database Administration Commands

To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the MySQL server. mysql> create database [databasename]; List all databases on the MySQL server. mysql> show databases; To delete a database. mysql> drop database [database name]; To delete a table. mysql> drop table... Continue Reading →

Deploying PostgreSQL on a Docker Container

PostgreSQL, often simply "Postgres", is an object-relational database management system (ORDBMS) with an emphasis on extensible and standards-compliance. As a database server, its primary function is to store data, securely and supporting best practices, and retrieve it later, as requested by other software applications, be it those on the same computer or those running on... Continue Reading →

Create Hot Backups of MySQL Databases with Percona XtraBackup

Introduction Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:  Backups that complete quickly and reliably  Uninterrupted transaction processing during backups  Savings on disk space and network bandwidth  Automatic backup verification Higher uptime due to faster restore time Percona XtraBackup makes MySQL hot backups for... Continue Reading →

Installing MySQL 5.6 on Ubuntu 14.04

Ubuntu 14.04 defaults to MySQL 5.5, but also has MySQL 5.6 available for installation from the  universe archive. Step 1: Install MySQL Server 5.6 Install mysql-server 5.6 with apt-get command : sudo apt-get update sudo apt-get install mysql-server-5.6 To install MySQL 5.6, install the mysql-server-5.6 package instead. sudo apt-get install mysql-server-5.6 There are two ways to install MySQL.... Continue Reading →

Install MySQL Server 5.6 (CentOS/Redhat)

Introduction In October 2013, the MySQL development team officially launched support for yum repositories. This means that you can now ensure that you have the latest and greatest version of MySQL installed directly from the source!.In this guide we will install MySQL 5.6 on a fresh installation of Centos 6. Installing MySQL The yum repository... Continue Reading →

Powered by WordPress.com.

Up ↑