I already wrote about auto-completion in the MySQL/MaiaDB command-line client using an auto-rehash feature. Recently I found out a new tool called mycli. It is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. This tool is written in Python. You need to use pip command to install it on […]
In this script an automatic FTP backup will pickup up your sql.tar.gz and upload the file to a remote FTP server running CentOS. So, you may wonder how all this works and how to automate entire procedure to be able to upload file /tmp/backup/sql.tar.gz?In the most simple scenario you can use a standard FTP client to transfer […]
In this tutorial, we will explain how to create a new user and grant permissions to that user in MySQL. MySQL is an open source relational database managed system(RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can […]
In this script an automatic FTP backup will pickup up your sql.tar.gz and upload the file to a remote FTP server running CentOS. So, you may wonder how all this works and how to automate entire procedure to be able to upload file /tmp/backup/sql.tar.gz? In the most simple scenario you can use a standard FTP […]
![[Tutorial] Set Up Database Replication In MySQL](https://yaoyuan.org/wp-content/uploads/2017/03/linux.jpg)
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.
These are the steps that we will do in this tutorial:To disable SELinux , edit the file /etc/sysconfig/selinux , and change enforced to disabled .
Introduction In this article, we will show you how to install LAMP stack on Ubuntu 16.04. It is a common web stack used for hosting contents on the web. The term LAMP is an acronym for the group of open source softwares which represents Linux, Apache, MySQL and PHP. In this case, we are using […]
Objective: to transfer the mysql library from A to B. 1, stop the MySQL service first, find out my.ini file and open it in the mashine A MySQL installation directory, find out dataDir in this file, copy ibdata1 and all files and all folder to the d:\mysql_data folder in the B machine except log file,(do […]