Database Administrator

Question 1: synchronizing data from MySQL 5.1 to the 5.5 Library Today, when synchronizing data from MySQL 5.1 to MySQL 5.5, a problem occurs in the sub-database: show slave status \ G. The error is as follows: Error 'BIGINT UNSIGNED value is out of

Ing SQL Server database users to login users Recently, a friend of mine accidentally shot the SQL server database. After several twists and turns, the data restored the database to the new environment. After recovery, there will be a user name at

One-click creation of a blackhole slave DatabaseDriven by business Some time ago, Weibo's two-way attention to business splitting increased the number of database instances several times. Correspondingly, we need to build many blackhole slave

Oracle AVDF installation, Next: Introduction to Oracle audit and database firewall (AVDF) 1. Oracle AVDF installation and configuration Oracle AuditVault and Database Firewall installation is a little troublesome and requires high hardware

MFC-related MYSQL database operations, mfcmysql database-related I remember someone said that the current software is basically connected to the database. If a software is not connected to the database, it will basically be useless. Although such a

Configure Mysql to allow remote access in Linux. The procedure is very simple. The procedure is as follows: 1. Go to mysql: /Usr/local/mysql/bin/mysql-u root-p 2. Use the mysql database: Use mysql; 3. view the user table: SELECT

Java Redis and javaredis The related concepts of Redis are not introduced. You can also understand Memcached first, and then compare the differences between the two, so you will have an overall impression. The server usually chooses Linux, and

[Practice] The sphinx configuration file, # Source src1 {type = mysql SQL _host = localhost SQL _user = root SQL _pass = password SQL _db = test SQL _sock =/usr/local/mysql. sock SQL _query_pre = set names utf8 SQL _query_pre = replace into

Join update vs sub-selects update, joinsub-selects During the process of using multi-table join for updates, I found that no correct update record was found (a condition problem was found afterwards). I have never used Association update before. I

Install Multiple mysql services on one host and multiple mysql instances on one host 1. mysql installation (omitted) 2. Stop the mysql Service 3. Copy all mysql files to another directory () 4. Open the my. ini file under the copy

In Linux, MySQL forgets the root password 1.1 and mysqlroot.1. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database at will.Because, during the resetting of the MySQL root Password, the MySQL database

OGG capture process stopped (OGG-01028), oggogg-01028 due to shift of archived logsThe user recently reported that the crawling process of OGG deployed on RAC Node 1 has been stopped for several days. You want to troubleshoot the problem and restore

Transact-SQL programming, transactsqlTransact-SQL programmingTransact-SQL(1) Data Definition Language (DDL)Create tabl/* create Table */Alter table/* Modify table */Drop table/* Delete table */(2) data manipulation language (DML)Select/* retrieve

Mysql batch imports text data into the database C language (c api), mysqlapi In fact, the principle is very simple. I think everyone should have read the article I wrote (a code learns to operate databases in C) on linux, the basic student

Installation manual for a single Oracle 12c instance and 12c installation manual for linux 6.4  I. Preparations  1.1 install the required RPM package   Binutils-2.20.51.0.2-5.11.el6 (x86_64) Glibc-2.12-1.7.el6 (x86_64) Libgcc-4.4.4-13.el6

Lo exception: The Network Adapter cocould not establish the connection, myeclipseestablish (1) recently it was really depressing to use DB Browser in Myeclipse, but the teacher encountered the following problems: (2) then hurry up to Baidu and

Oracle undo Reading Notes, oracleundo Two parameters related to undo: Undo_tablespace UNDO_MANAGEMENT = auto After oracle 9i, we recommend that you use undo for automatic management; Undo_retention This parameter is used to ensure that the

Check whether duplicate data is stored in the table before oracle inserts data. Sometimes, when inserting data in an oracle database, you need to determine whether the data already exists. Our first thought is as follows: first, execute the

Database index Principle An index is a structure that sorts the values of one or more columns in a database table (for example, the last name (lname) column of the employee table. If you want to search for him or her by the name of a specific

For a brief introduction to the environment variable ORACLE_SID, the environment variable oracle_sid[Oracle10g @ lixora ~] $ Export ORACLE_SID = 12323[Oracle10g @ lixora ~] $! SQLSqlplus/as sysdbaSQL * Plus: Release 10.2.0.1.0-Production on Thu Nov 6