MySQL

In the previous article "InnoDB Source analysis of the redo log structure" We know the basic structure of redo log and log writing steps, then redo log is how to recover data? When is the log deduction for redo log? Redo log deduction only after the

Test environment: MySQL 5.0.45 "NOTE: You can use mysql> Select version () in MySQL to view the database version"First, connect MySQL.Format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine.First open the DOS

Commands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the

After installing PHP and MySQL on the Linux CentOS system, for convenience, PHP and MySQL commands need to be added to the system commands, if you do not add to the environment variable, execute "php-v" command to view the current PHP version

A batch file that was written earlier when the MySQL interface was debugged.Register to start My_install.bat@echo Offset Mysql_dir=%~dp0rem set mysql_dir=%cd%if not "%mysql_home%" = "" ( If not "%mysql_home%" = = "%mysql_dir%" ( echo mysql_

Mysqlhotcopy Use the lock tables, flush tables, and CP or SCP to quickly back up the database. It is the quickest way to back up a database or a single table, which is completely physical, but only used to back up MyISAM storage engines and run in

For MySQL, there are three levels of Lock: page level, table level, row levelThe typical representative engine for the page level is BDB.The typical representative engine for the table level is myisam,memory and the ISAM of a long time ago.The

After reading a few documents, have not written completely. A little tidying up, re-step to compile and install MySQL on the centos7.The installation steps are as follows:1. Install the compilation environment # yum-y Install gcc-gcc-

MySQL import source times wrong MySQL error 1153 (08s01) Max_allowed_packet not big enoughRecently need to import MySQL backup files, when using the source command to import, but reported the following error: Error 1153 (08S01): Got a packet bigger

The Java JDBC Connection database is an entry-level database experiment where code is posted to facilitate later reading.Package Com;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.preparedstatement;import

http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html installing MySQLRpm-qa | grep mysql//This command will check if the MySQL database is already installed on the operating systemRPM-E--nodeps MySQL//brute force Delete mode, if

MySQL periodically calls the stored procedure to back up the table data set table structureStored Procedure instance:CREATE PROCEDURE backupsms () begindeclare tname varchar (+), set @tname = CONCAT (' Sms_accpet ', Date_format (now (), '%y%m ') Set

Iv. creating a database using visual ToolsAlthough using the command line feels more like our programmers, I prefer to use Workbench to create a database. first Open the workbench, a more friendly interface on the open, haha. I still prefer this

MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup scripts/etc/init.d/mysql (startup

Problem Recurrence (The following discussion is for Windows environments only):C:\appserv\mysql> Mysql-u Root-pEnter Password:ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)Edit the MySQL profile My.ini(do

Chat about MySQL InnoDB storage engine (i)Chat about MySQL's InnoDB storage Engine (ii)Chat about MySQL InnoDB storage engine (end)In this paper, we discuss the processing method of Phantom reading in InnoDB engine and the detection of deadlock and

The post demonstrates how to build replication environment with 2 new MySQL servers which is running on 64-bit U Buntu 14.04 LTS machines. Master: {mysql:5.7.5, IP Address: 192.168.0.100} Slave : {mysql:5.7.5, IP Address: 192.168.0.101}

SpagoBI4.2 and configuring MySQL database tutorial 1. Install MySQL database 2. Install the JDK and configure the Java environment variables 3. Download SapagoBI4.2 ALLinONE installation package 4. Unzip the SpagoBI

Original: MySQL green version configuration and use of detailedI recently used MySQL database in project development, and after reading some articles about MySQL, I quickly started using it. There are still some problems in the use of the process,

One, primary server (Master) configuration1. Modify the MySQL configuration file