Database Administrator

Detailed introduction to mysqldump Note: mysqldump is a tool used by the database for backup and data transfer. It can be used for backup when the data volume is small (several GB. When the data volume is large, mysqldump is not recommended for

Debugging record of MySQL storage function error [Err] 1064 1. An error is reported when a user creates a storage function.Create definer = 'root' @ 'localhost' FUNCTION 'stuff '(F_old varchar (1000), f_start int, f_length int, f_replace varchar (100

MySQL Database Import and Export When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work: Import: Import data

1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user

Keywords: host string in Oracle If the local SQL * Plus is used to connect to the local database, the "host string" can be blank. To remotely connect to the xp oracle database, use the following method:1. Start oracle-related servers in windows;2.

Finally, Oracle 10 Gb is successfully installed on RedHat Enterprise Linux 5.5 x64. The entire process is recorded as follows: I. Preparations before RHEL5 Installation 1. Set swap Partition Oracle 10 Gb installation requires that the swap space be

Oracle session and connection optimization, oracle session 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQL> show parameter processes; NAME TYPE VALUE----------------------------------------

Db2v8 data migration and db2v8 migration Db2 data migration Version: v8.1 Task: get data from production to test environment Problems encountered during handling: 1. Character Set problems. The source database code page is gbk, and the target

Analysis on the storage format of Oracle nested tables and oracle nesting Oracle nested tables are rarely used. The following describes how to store them. For example, a user corresponds to a department. SQL> select * from v $ version;BANNER---------

SQL advanced (8) data type, SQL data typeSQL advanced (8) data type Character string: Data Type Description Storage Char (n) A fixed-length string. It can contain a maximum of 8,000 characters. N Varchar (n)

Oracle Data Pump remote import file to local database, oracle import database-- Log On As A dbaC: \ Users \ Administrator> sqlplus/as sysdba-- Create a userSQL> create user bfzg0828 identified by bfzg0828 default tablespace users quotaUnlimited on

Vertica7 Native Connection Load Balance, vertica7native Original article: Vertica7 Native Connection Load Balance In versions earlier than Vertica7, Vertica implements Server Load balancer through the Virtual IP address of Linux. However, in

An error occurred while executing the SQL client in hive. The hivesql Client FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exe c. DDLTask. java. lang. RuntimeException: Unable to instantiate org. apache. hadoop. hive.

How to download the Grid method (Oracle RAC) on the OTN website, otngrid How to download grid software required by RAC Register an account and log on to the OTN website. Go to the download options and find the "server and storage system"

Can't connect to mysql server on localhost , localhost10061 You need to start the MySQL service. You can start MySQL in two ways: 1. command line. Win + R, Enter cmd and press Enter. In the command line window, enter: Net start mysql56 Mysql56

Online expansion of database UNDO tablespaces and expansion of database undo tables Log on to the oracle database server with an ORACLE account Method 1: View the tablespace name and file location: select tablespace_name, file_id,

A ORA-14450 attempt to access a transactional temp table already in use, ora14450 An error occurred today when adding a field to the temporary table: ORA-14450 attempt to access a transactional temp table already inuse The reasons for improper use

Establish RAC in AIX (1) detection system environment, aixrac Establish a series of RAC instances under AIX Environment Node Node 1 Node 2 Small Machine Model IBM p-series 630 IBM p-series 630 Host Name AIX2

Duplicate entry '000000' for key 1, duplicateentry 1. Error description 939 10:27:13, 104 ERROR (com. you. conn. JDBCConnection: 97112)-com. mysql. jdbc. exceptions. jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '20140901' for

Example (5) modify the column value on the primary key. The update operation is split into two statements. Continue with "Example of the upload data experiment (4) Verify that the upload data finds out the non-synchronization caused by the updata