Database Administrator

How to reset the MySQL Database Password How to reset the MySQL Database Password Method 1:Add the following to the [mysqld] field of my. ini:Skip-grant-tablesRestart the mysql service. mysql can log on to the database without a password.Then go

How to deal with Oracle DataGuard archive log loss A database is configured with Physical Transaction uard (hereinafter referred to as dg). Because no check is performed, the archive day is deleted on the master database, and the slave database is

XtraBackup enables MySQL to redo master-slave replication without stopping services You can use mysqldump to implement MySQL master-slave synchronization without stopping services, but this efficiency is relatively low. XtraBackup is used to achieve

How to Use binlog to restore valid data after MySQL Data is lost Enable binlog, edit the my. cnf file, and add Log-bin = mysql-bin # enable the binary log and specify the path and file name, if not set, by default in the data storage directory, the

ORA-01658: Unable to create INITIAL partition for segments in tablespace space Error When imp imports data: ORA-01658: Unable to create INITIAL partition for segments in table space MAXDATA An error occurred while creating a table in Oracle: ORA-0

MySQL 5.6 master-slave synchronization configuration case MySQL 5.6 master-slave synchronization configuration case sharing, I hope to help you. EnvironmentMaster Database: CentOS6.5 x64 192.168.0.65 mysql-5.6.29Slave Database: CentOS6.5 x64 192.168.

MySQL Log File Type Introduction: MySQL provides various types of log files that reflect different MySQL information and are necessary to understand them. 1. Error log (Error log) The error log records all severe warnings and error messages during

MongoDB full-text index usage How to create a full-text index for MongoDB:Db. ensureIndex ({key: "text "})Db. ensureIndex ({key1: "text", key2: "text "})Db. ensureIndex ({"$ **": "text", key2: "text "}) Usage of mongodb full-text index query:Db.

MySQL common precautions Fuzzy search like indexes the name field by default.Note: When fuzzy search is used, the index cannot be used when % is at the first letter. However, % indexes can be used at other locations. # Select * from tableName

Oracle implements simple data desensitization through expdp remap_data Starting from Oracle 11g, The remap_data parameter is provided in impdp/expdp to convert data during import or export operations. if the production database data needs to be

MongoDB Limit and Skip MethodsMongoDB Limit () method If you need to read a specified number of data records in MongoDB, you can use the Limit Method of MongoDB and the limit () method to accept a number parameter, which specifies the number of

MySQL binlog secure deletion Introduction: If you have set up master-slave synchronization for MySQL or enabled log-bin for the database, a large number of log files will be generated in the data directory of your database over time. Shell>

MongoDB-instance connection instructionsConnect to MongoDB through shell You can connect to the MongoDB service by executing the following command. Note: localhost is the host name. This option is required:Mongodb: // localhost When you execute the

Use normal users instead of root to manage IEE Environment: RHEL 6.4 + IEE 4.0.6Requirement: the IEE database was previously deployed and managed by the root user. Now, the security reinforcement function is used to send the database to the normal

Configuration Modification of MariaDB database storage path MySQL is not running, but lock file (/var/lock/subsys/mysql) existsThis problem is generally caused by three reasons:1: some files in the configuration are not authorized enough. Change all

MySQL displays the name of the connected database By default, MySQL does not display the name of the connected database when using databasename!Mysql> show databases;+ -------------------- +| Database |+ -------------------- +| Information_schema ||

MySQL Tutorial: I/O Memory Optimization Mysql Ver 14.14 Distrib 5.6.19, for Linux (i686) using EditLine wrapper I. mysql directory files Ibdata1: The system tablespace contains data dictionaries, rollback logs, and undolog. (Insert buffer

Install MySQL 5.6.26 through source code in CentOS6 MySQL 5.1 installed through yum in CentOS6 is old, so I want to install the later version 5.6.26 through the source code. I. Uninstall the old version Run the following command to check whether

The 11g asm disk cannot be automatically mounted. I started ASM today and found that only one SYS_DG DISK is mounted (used to store OCR and VOTING DISK information). The other two DISK groups DATA_DG and DG_FRA do not mount.Environment: OS = RHEL 6

The method for assigning values to SQL fields unrelated to the business in the CRUD operation, crudsql Improving efficiency has always been an eternal topic. One of the topics in programming can also mention efficiency, that is, focusing on one