Database Administrator

Error analysis during data import using MySQL5.6 A strange error occurred when importing data exported by mysqldump today? ERROR 1064 (42000) at line 13327: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

SQL Server 2016 RC0 installation (over multiple images) Microsoft's latest version of Database SQL Server 2016 launched RC0 in March 9, 2016. Multiple language versions are provided, including simplified Chinese, but the online books are still in

MySQL Replication-(Instance) Master-slave replication Principle MySQL Replication is an asynchronous Replication process that replicates data from the Master to one or more Slave instances. The entire replication process between the Master and

MySQL 5.6.12 database compilation and installation in Linux MySQL 5.6.12 database compilation and installation in Linux Download the mysqldata library and download it from the official network. Here, the download is mysql-5.6.12.tar.gz2. Download

How to Use Jedis to operate Redis message queuesResources Jedis jar packageCommons-io jar packageUsage The sample code is as follows. before using it, open the redis server program.Sample Code Package RedisExample; import redis. clients. jedis.

How to Set Up MySQL synchronization (replication) MySQL provides the Database Synchronization function, which is of great help to achieve database redundancy, backup, recovery, and load balancing. This document describes common synchronization

Application change deployment in production mode of Weblogic Scenario overview The next AdminSever in production mode allows WebLogic to manage multiple managedsevers. When deploying an application for the first time, you can select multiple

Oracle 11g solves the problem of User Password Expiration After using Oracle 11g, often encounter the use of sqlplus login oracle Database prompts "ORA-28002: 7 days after the password will expire" and so on. Search for relevant information. It is

MySQL execution Status Analysis When you feel that MySQL performance is faulty, you will usually first check the current MySQL execution status and use show processlist to view it. For example: The state column information is very important. First,

Oracle bidirectional Stream configuration practices Abstract: This article describes how to use the Oracle Stream replication function for Bidirectional Stream replication. It is mainly used for real-time database synchronization and backup. Oracle

Migration of data files in the slave uard slave Database A few days ago, I also spent some time testing the migration of data files in the standby database. This part of work seems to be more common, of course, there are many methods. However, in

MySQL Q & A · mysqldump tipsBackground When using mysqldump to export data to the cloud, you may encounter two "weird" problems.TIP 1 -- port is invalid? For instances with ports 3306 and 3307, run the following command: mysqldump --host=localhost --

Hive installation and configuration notes Hive metadata Storage Methods1. Derby: the default hive storage mode. You cannot call hive concurrently.2. Local MySQL3. Remote MySQL Use the second method to install MySQL, start and create Hive users, and

MySQL batch insert data script MySQL batch insert data script #! /Bin/bashI = 1;MAX_INSERT_ROW_COUNT = $1;While [$ I-le $ MAX_INSERT_ROW_COUNT]DoMysql-uroot-proot dbname-e "insert into tablename (name, age, createTime) values ('Hello $ I ', $ I % 9

How to allow users to access only specific databases (MSSQL) Background The customer's SQL Server instance has databases of multiple vendors. Each database is maintained by its own manufacturer. to limit that maintenance personnel of different

Integer Range in 32-bit and 64-bit PHP and MySQL A single byte has 8 bytes, so the 32-bit int type occupies 32-bit/8-bit = 4 bytes, And the 64-bit int type occupies 64-bit/8-bit = 8 bytes. 32-bit, 64-bit unsigned integer maximum value:2 ^ 64-1 = 184

Remove time zone and precision from PostgreSQL query results I have been using PostgreSQL functions to piece together. Today I suddenly found that it can be so simple, just use timestamp (0) to solve it: Ls => select createtime: timestamp (0)

Why does HBase need to build an SQL engine layer? The existing SQL solutions are generally not horizontally scalable, so when the data volume changes, it will encounter obstacles. However, with the emergence of NoSQL, it has been greatly mitigated,

MySQL displays data too long for column 'name' at row 1 1. symptom: we set the character set encoding of the database to UTF-8. When we insert Chinese characters to a column in the table through the DOS interface, we will encounter a similar

Easily solve the problem of too many MySQL database connections 1. Maximum number of connections allowed by the MySQL database system max_connections. This parameter can be set. If this parameter is not set, the default value is 100. The maximum