Database Administrator

1. Check whether Mysql is installed in Linux. [Root @ localhost zhoulinghong] # rpm-qa | grep MySQL MySQL-server-community-5.1.22-0.rhel4 Already installed. 2. Install mysql (rpm) in Linux) [Root @ localhost zhoulinghong] # rpm-ivh

I have sorted out some solutions to the Mysql problem in the FreeBSD environment for your reference! 1. An error occurred while modifying the root user password: # Mysqladmin-uroot-p password 'newpassword' Enter password: Mysqladmin: connect to

In practice, you sometimes need to modify the user name, and the common practice is the exp imp method. If the data volume is large, the exp imp method will waste a lot of time, the following describes how to modify the user name by modifying the

After several days of hard work, I finally succeeded in the Fedora core files, which really made me suffer a lot, because I have stored N database files, because I have never doubted it, I suspect that my downloaded file has been damaged (including

1. Use the root user to modify the/etc/oratab file: $ Gedit/etc/oratab Orcl:/Oracle/app/product/10.2.0/db_1: N Changed: Orcl:/Oracle/app/product/10.2.0/db_1: Y That is, change the last N to Y. 2. Use the Oracle user to modify the $

Summarize the causes of the problem: When I install snort, The./configure -- with-mysql = DIR path indicates a problem. My system has installed mysql So when I reinstall it, I directly./configure -- with-mysql, and uninstall the snort before the

The following information is displayed: Got an error: Connection error: Can't connect to local MySQL server through Socket '/var/lib/mysql. sock' The sudden disappearance of mysql. sock is a common problem. If it occurs after MySQL is installed

After the archived logs are manually deleted, the Rman backup detects that the logs are missing and cannot be further executed. Therefore, you need to manually execute the crosscheck process, and then the Rman backup can be restored to normal. 1.

1. Export the entire database Mysqldump-u username-p Database Name> exported file name Mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL 2. Export a table Mysqldump-u user name-p database name Table Name> exported file name Mysqldump-u wcnc-p smgp_rj_wcnc

Databases are the main part of Linux applications. Major databases on Linux include: Oracle, Sybase, DB2, Informix; Free Software databases: MySQL, PostgreSQL, and Msql. Commercial database As commercial databases have good technical support, I

Considerations for importing and exporting Oracle databases1. When Oracle exp exports the dmp file, the storage clause defined by the table structure is exported by default, and the compress parameter is Y by default, after repeated exp and imp

1. Log On with the root user in LinuxUseradd OraclePasswd oracleVi/etc/sysctl. confAdd:Kernel. shmall = 2097152Kernel. shmmax = 2147483648Kernel. shmmni = 4096Kernel. sem = 250 32000 100 128Fs. file-max = 65536Net. ipv4.ip _ local_port_range = 1024 6

The code tree of mysql proxy has been migrated to lauchpad and bazaar is used for version management. According to some documents, the latest mysql proxy is successfully compiled and installed under CentOS 5.2. The procedure record is as follows (it

MySQL slow query record logs are useful for tracking MySQL load tuning issues in the PHP + MySQL system, such as installing a lot of Discuz! Plug-in users, so that you can probably find out which plug-ins have code problems. In fact, it is very easy

You can create and delete indexes in two ways: alter table and create/drop index. alter table:Alter table tbl_name| ADD {INDEX | KEY} {INDEX_NAME}{INDEX_TYPE} (INDEX_COL_NAME,...) [INDEX_OPTION] ......| DROP {INDEX | KEY} INDEX_NAME Alter table

I sent a SR on MOS and asked how v $ segment_statistics was updated? Oracle: v $ segment_statisitcs has been used for internal research since 9IR2 was introduced] (I) first look at the table structure: Sys @ ORCL> desc v $ segment_statisticsName

UPDATE queries are tricky because you cannot simply write multiple values. In different situations, I use different solutions. If you are sure that the record to be updated exists, you can use INSERT... on duplicate key update instead (Leave a

I found this problem in my work: in Oracle versions earlier than 10 Gb, there is a bug that PreparedStatement preprocessing is used to dynamically query data, using placeholders? If the field is of the char type, it is used to replace it during

Silly, the simplest way to write Oracle_database_linux32.zip indicates the installation package name.   #! /Bin/bash ################### Yum and rpm ################## # Touch/etc/yum. repos. d/1. repo Echo "[1]">/etc/yum. repos. d/1. repo Echo

Oracle 11g has a new feature. Replace the variable in the RMAN script. Today, I did a small experiment on the server and tried this feature. Although some errors have been made, all of them have been solved! I feel that this feature is still good.