• Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us
TecAdmin
Menu
  • Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us

Category: MariaDB

20 October 2019

How to Install MariaDB 10.4 on CentOS 8 & RHEL 8

Written by Rahul
Rahul
MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and...
Read More about How to Install MariaDB 10.4 on CentOS 8 & RHEL 8
CentOS, MariaDB Leave a Comment
13 November 2018

How To Install MariaDB on Debian 9 (Stretch)

Written by Rahul
Rahul
MariaDB is an enhanced, drop-in replacement for MySQL. MariaDB can be a better choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. This article will help you to Install MariaDB 10.4 on Debian 9 (Stretch) via apt package manager. Step 1...
Read More about How To Install MariaDB on Debian 9 (Stretch)
MariaDB 2 Comments
02 October 2017

How to Install MariaDB 10.4 on CentOS/RHEL 7/6

Written by Rahul
Rahul
MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and...
Read More about How to Install MariaDB 10.4 on CentOS/RHEL 7/6
MariaDB 5 Comments
30 July 2017

An Advance Bash Script for MySQL Database Backup

Written by Rahul
Rahul
After writing a simple shell script for MySQL database backup. This is our new advance bash script for MySQL database dump. This script will provide you to backup MySQL database and upload backups to various remote locations like FTP, SFTP and Amazon s3 bucket. This script is available on our Github account with all...
Read More about An Advance Bash Script for MySQL Database Backup
Bash Shell, MariaDB, MySQL 11 Comments
17 June 2016

ERROR 2006 (HY000) at line XXX: MySQL server has gone away

Written by Rahul
Rahul
MySQL database restoration process failed with a error message while restoring a large backup file. I got the below message. After reading about this problem i found that this is not with size of backup, this problem occurred when a single package size is greater than allowed packet size. [email protected]:~$ mysql -p mydb <...
Read More about ERROR 2006 (HY000) at line XXX: MySQL server has gone away
MariaDB, MySQL Leave a Comment
17 May 2016

How To Find MySQL my.cnf File Location

Written by Rahul
Rahul
MySQL configuration file (my.cnf) file location depends on operating system or installation method. There are no command available to trace this file location on your system. In this tutorial you will get some default location’s of my.cnf file can be found. /etc/my.cnf /etc/mysql/my.cnf $MYSQL_HOME/my.cnf [DATADIR]/my.cnf ~/.my.cnf In case my.cnf file is available on more...
Read More about How To Find MySQL my.cnf File Location
MariaDB, MySQL 2 Comments
03 April 2016

How to Create, List or Drop Indexes on MySQL Table

Written by Rahul
Rahul
Indexes are very useful to improve search queries on database tables. For example you are searching for particular record in a database table having millions of records. You will find that search queries taking very less time on tables having indexes enables. CREATE INDEX:- This will creates index on mysql table. This will allow...
Read More about How to Create, List or Drop Indexes on MySQL Table
MariaDB, MySQL Leave a Comment
10 November 2015

How to Temporarily Disable Foreign Key Checks in MySQL

Written by Rahul
Rahul
You must have faced the foreign key constrains issues many times while working with MySQL database. Generally this issue occurred during delete, insert records, backup and restore database and drop database and drop tables. In this situation its hard to complete task. MySQL provides an option to disable foreign key checks during any operation...
Read More about How to Temporarily Disable Foreign Key Checks in MySQL
MariaDB, MySQL Leave a Comment
10 August 2015

How To Enable Logs in MySQL Server

Written by Rahul
Rahul
The log file plays an important role during the troubleshooting of any application. It’s also useful to find about details about of running application. This article you will show you to how to enable different types of logs in MySQL server. Also, you will understand how to change log file locations in MySQL server....
Read More about How To Enable Logs in MySQL Server
MariaDB, MySQL 3 Comments
22 July 2015

How to Remove/PURGE BINARY LOGS in MySQL & MariaDB

Written by Rahul
Rahul
Binary log files contains data about modification’s make by MySQL server. You can see there are multiple binary files will be available on your MySQL server and there will be one .index file which contains names of all binary files to keep track of them. Step 1. List Binary Files First list binary log...
Read More about How to Remove/PURGE BINARY LOGS in MySQL & MariaDB
MariaDB, MySQL 1 Comment
1 2 3 Next →

Popular Posts

  • How to Install Python 3.8 on Ubuntu, Debian and LinuxMint
  • How to Restart Network Service on CentOS 8 or RHEL 8
  • How to Check IP Address on CentOS 8
  • How to Install Java 11/8 on Amazon Linux
  • How to Configure Static IP on CentOS 8 (CLI)
Copyright © 2013-2019 TecAdmin.net. All Rights Reserved. This site uses cookies. By using this website you agree with our term and services
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
Revoke cookies