NAV: SLTechnology News&Howtos > Database >

• 

  How to manage and authorize MYSQL account

  This article mainly introduces how to manage and authorize the MYSQL account, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance to everyone's reference. Let's work with the author to understand how to manage and authorize the MYSQL account. User account number:'u

  2022-06-01 17:55:24 Views: 203
• 

  How to realize mysqldump simple backup and recovery

  The following mainly brings you how mysqldump simple backup and recovery is realized. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit mysqldump simple backup and restore. All right, no more nonsense, let's just take a look at it.

  2022-06-01 17:55:24 Views: 298
• 

  Oracle 10g install ASM (RHEL5)

  1. View the package required to install ORACLEASM on the system version uname-r current environment is 2.6.18-164.el5 download the corresponding package to install http://www.oracle.com/technetwork/se

  2022-06-01 17:55:22 Views: 232
• 

  How to realize mysql Row transfer

  The following together to understand how to achieve mysql row transfer, I believe that we will benefit a lot after reading, the text in the essence is not much, hope that how to achieve mysql row transfer column this short content is what you want. The raw data is as follows: mysql > select id,sdkname

  2022-06-01 17:55:22 Views: 284
• 

  Detailed tutorials for installing MySQL databases

  I do not know if you have any knowledge of the articles similar to the detailed tutorials of installing MySQL database before, but I will give you a brief introduction here today. If you are interested, let's take a look at the body. I'm sure you'll get something after reading the detailed tutorial on installing MySQL database. 1) create m

  2022-06-01 17:55:21 Views: 205
• 

  Introduction to mysqldump, a tool for mysql backup

  Let's talk about the mysql backup tool mysqldump. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe that after reading the mysql backup tool mysqldump to introduce this article, you will certainly benefit. Node 1

  2022-06-01 17:55:21 Views: 235
• 

  How to optimize the performance of mysql

  The following brings you about the performance of mysql how to optimize the content, I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I believe you will gain something after reading how to optimize the performance of mysql. File system: optimizing file system

  2022-06-01 17:55:21 Views: 214
• 

  What is the logical backup and recovery of Mysql

  Let me tell you a little bit about what is the logical backup and recovery of Mysql. Have you learned about similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading what is the logical backup and recovery of Mysql. In MySQL

  2022-06-01 17:55:21 Views: 266
• 

  Summary of related settings of mysql

  The following brings you a summary of the relevant settings of mysql, if you are interested, let's take a look at this article. I believe it will be of some help to you after reading the summary of the relevant settings of mysql. 1. To install MySQL, run the following statement with administrator privileges to get mysql and Pyt

  2022-06-01 17:55:20 Views: 225
• 

  Find top sql information through operating system processes

  SELECT 'USERNAME:' | s.username | | chr (10) | | 'SCHEMA:' | | s.schemaname | | chr (10) | |' OSUSE

  2022-06-01 17:55:05 Views: 250
• 

  Introduction of mysql database model, management table and index under linux

  This article is mainly about the mysql database model, management tables and indexes under linux. If you are interested, let's take a look at this article. I believe that after reading the mysql database model under linux, the management tables and indexes are of some reference value to everyone.

  2022-06-01 17:55:05 Views: 283
• 

  Detailed explanation of several common methods for installing MySQL in CentOS system

  This article is mainly about CentOS system installation MySQL commonly used several aspects of the content, if you are interested to take a look at this article, I believe that after reading the CentOS system installation MySQL commonly used several sides to you more or less reference value. Install on Linux

  2022-06-01 17:55:05 Views: 279
• 

  12c rac to rac dg encountered an error about permissions

  1. Environment description redhat 7.0Oracle 12.1.0.2RAC TO RAC DG 2. Error message DGMGRL > add database 'orcldg' as connect identifie

  2022-06-01 17:54:58 Views: 212
• 

  Error in invoking target 'agent nmhs' of makefile

  In the morning, I was informed that I needed to configure a set of oracle database for goldengate synchronization. When I received the system from the system personnel, I installed the system. I wanted to install the database software. As a result, I was surprised that this tabloid error should have something to do with the version of the system.

  2022-06-01 17:54:58 Views: 296
• 

  Linux Notes 13

  Master-slave DNS synchronization when a single DNS can not meet the needs of customers is to open a synchronous secondary DNS, their dns content is the same. Host: vim / etc/named.rfc1912.zoneszone "asd.com" IN {type

  2022-06-01 17:54:43 Views: 211
• 

  Group functions of SQL Foundation (9)

  Group functions:-types and syntax-use AVG, SUM, MIN, MAX, COUNT- group functions use the DISTINCT keyword-group functions with NULL values in group functions: act on a set of data and return a value group function for a set of data

  2022-06-01 17:54:29 Views: 297
• 

  Oracle 11g R2 View

  The view is a virtual table that does not take up physical space because the definition statements of the view itself are stored in the data dictionary. The data in the view is obtained from one or more actual tables. Materialized views: also materialized views, which contain actual data, occupy storage space, and are often created by materialized views in data warehouses.

  2022-06-01 17:54:24 Views: 219
• 

  Rhel 6.5 install oracle 11g

  1. Install RPM package yum install-y binutils elfutils-libelf glibc compat-libstdc++-33.x86_64 libgcc unixODBC jav

  2022-06-01 17:54:21 Views: 276
• 

  Management and use of PFile and SPFile files

  Abstract the parameter file in ORACLE is an operating system file containing a series of parameters and their corresponding values, which can be divided into two types of PFile and SPFile. They are loaded when the database instance is started, which determines the physical structure, memory and data of the database.

  2022-06-01 17:54:21 Views: 275
• 

  How to rewrite a startup script

  What this article shares with you is how to rewrite the startup script. I believe that most people have not yet learned this skill. In order to let you learn, I have summed up the following contents. Without saying much, let's read on. ! / bin/bashuser=rootport=3306CmdP

  2022-06-01 17:54:20 Views: 288