• Batch command bat backup MySQL database


    Working environment: Windows Server 2003, MySQL installation directory: D: MySQL, WinRAR installation directory: C: program files: winrar\ WinRAR.exeBackup data storage path is e: data backup, OK, the following start to write DOS batch command. Copy codeThe code is as follows: set “Ymd=%date:~,4%%date:~5,2%%date:~8,2%” MD “E: – data backup \% YMD%”“D:\MySQL\bin\ mysqldump.exe “– opt – Q MySQL […]

  • Installation, configuration and uninstall of MySQL 8.0 in Windows Environment


    Software version Windows:Windows10 MySQL:mysql-8.0.17-winx64.zip Installation procedure 1. Configure environment variables name:Path value:C:\Program Files\MySQL\mysql-8.0.17-winx64\bin 2. New my.ini file File location: C: program files / MySQL / mysql-8.0.17-winx64\ my.ini(this is my installation directory. You can modify it according to your actual installation path.) [mysqld] #Port number (default: 3306) port=3306 #Set MySQL installation directory basedir=C:\Program Files\MySQL\mysql-8.0.17-winx64 #Set the […]

  • Installation and simple configuration of MySQL 8.0.17 under MacOS


    If I write this article you can’t understand, there may be no online tutorial you can understand Although this article is for version 8.0. X, there are still general methods for MySQL configuration Environmental information and scope of application# environmental information Environment / software edition macOS macOS Mojave MySQL MySQL 8.0.17 Scope of application Environment […]

  • Detailed explanation of MySQL 5.7 Mgr single master determining master node method


    Mgr of our bank will be online at the end of the year. We have to read official documents every day to learn, do tests, and write a little knowledge every day. Do you want to learn together~ MySQL 5.7 Mgr single master determines which primary node is. We can judge by member ID, and […]

  • Example of setting automatic creation time and modification time by MySQL


    This paper describes the method of setting automatic creation time and modification time by mysql. For your reference, the details are as follows: The first is defined by DDL CREATE TABLE `course` ( `course` varchar(255) DEFAULT NULL, `user` varchar(255) DEFAULT NULL, `score` int(11) DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `create_ time` datetime DEFAULT CURRENT_ […]

  • How to install mysql-5.7.9 in RPM mode under Linux system


    The installation process of mysql–5.7.9 64 bit RPM collection package in Linux system. Because I use 64 bit centos7, so I am under a 64 bit collection package. If you use a 32-bit Linux system, please download the 32-bit collection package. Here, I only talk about installation, and I don’t explain how to use commands, […]

  • Old bird takes you to develop professional MySQL startup script


    Every qualified Linux operation and maintenance personnel should be proficient or proficient in shell script programming, because shell scripting language is almost the simplest language in all programming languages. If shell script fails, it means that the operation and maintenance road may be coming to an end before it starts. ——Old boy teacher #!/bin/bash #Self […]

  • How to install MySQL 5.6 in win7


    1、 Download Mysql: https://dev.mysql.com/downloads/windows/installer/5.6.html Click the download button, and then click start download. You can download without logging in. 2、 Installation 1. Double click the setup program 2. Click agree agreement, next step 3. Select the installation version, select custom, next step 4. Select MySQL server 5.6 x64, check all of them, and then select […]

  • Transaction, index, lock principle and usage analysis of MySQL knowledge points


    This paper introduces the transaction, index, lock principle and usage of MySQL knowledge points. For your reference, the details are as follows: affair Transaction concept A transaction is a set of atomic SQL queries, or an independent unit of work. If the database engine executes a set of operation statements, then all operations will be […]

  • 36 principles of MySQL database development (summary)


    preface These principles have been summed up through actual combat Behind each principle is a bloody lesson These principles are mainly aimed at database developers and must be paid attention to in the development process 1、 Core principles 1. Try not to operate in the database As the saying goes: don’t let your toes think […]

  • Detailed steps of installing MySQL in win


    This article shared the detailed steps of installing MySQL in win for your reference. The specific contents are as follows MySQL download directory Select the installation free version of “windows (x86, 64 bit), zip archive” After decompression, create it in the MySQL decompression directory my.ini Examples are as follows: #Database server configuration item [mysqld] #Database […]

  • How to realize distributed lock with dB in MySQL


    preface Whether it is a single machine lock or a distributed lock, the principle is to judge the current operation behavior based on the shared data. For a single machine, it is shared RAM memory, and for a cluster, it can be realized with the help of redis, ZK, DB and other third-party components. Redis […]