Database Administrator

I have not used Mysql for a long time. Yesterday, my friend had no problem with running a small project on my machine, but reported an internal server error (500) on his machine ), using QQ for Remote Assistance (too slow), it took me half a day to

Uninstall MySQL in Linux 1. Check whether MySQL is installed before. Command: rpm-qa | grep-I MySQL We can see two MySQL packages: MySQL-4.1.12-3.RHEL4.1 MySQLclient10-3.23.58-4.RHEL4.1 2. Delete MySQL DELETE command: rpm-e -- nodeps package

Some Linux database servers use low-end storage. Due to service changes, some Luns are required. Must I restart a Linux server after adding a LUN? Use the QLogic fc hba lun Scan Utility script to identify newly added Luns without restarting the

Steps for installing a MySQL database in Ubuntu: 1.download mysql-6.0.4-alpha.tar.gz2. tar-zxvf mysql-6.0.4-alpha.tar.gz3. cd mysql-6.0.4-alpha4../configure -- prefix =/usr/local/mysql5. make6. sudo make install7. sudo cp

On the Rise, I wanted to use the C language to operate mysql in Ubuntu 8.04. After a half-day environment was built, I didn't know how to get it. I didn't find more information on the Internet. I probably won't check it, next I will record the

My system is Ubuntu 12.10 First, add the key: Apt-key adv -- keyserver keyserver.ubuntu.com -- recv 7F0CEB10 An error occurs as soon as it comes up: Executing: gpg -- ignore-time-conflict -- no-options -- no-default-keyring -- secret-keyring/tmp. PJ6

Simple setup of master-slave MySQL 192.168.190.128 "====" 192.168.190.129Master ---- slaveSlave ---- master 1. Configure the my. cnf file on the master 128 and add the following parameters:Server-id = 1Log-bin = mysql-binLog-salve-updatesSync_binlog

Abstract: when using the sybase database, we often use excel to read the content in excel and insert it into the sybase database table, in this process, there are often line breaks in excel (line breaks are not visible). After being imported to a

This version still does not solve the problem that dynamic libraries cannot be compiled. What are the nerves of MongoDB? It turns out that the two bypass methods will not work either. Only static databases are used. Download and compile the latest

Basic Ideas MongoDB is used as an in-memory database, that is, it does not allow MongoDB to save data to a disk at all, which has aroused more and more people's interest. This method is extremely useful for the following applications:

Scenario Description: A friend asked, ms SQL server will back up the database to restore to other machines is very convenient, basically is a silly operation, Oracle control files, parameter files a bunch of things, I think the restoration is very

RHEL6 ASM installation of Oracle 11g R2 tutorial directory: I. Preparations before installationIi. Install the grid infrastructure3. Install database software4. Create a listener5. Create a database instance I. Preparations before installation 1.1

Recently, in the project, because the system needs to provide the database backup function, after some online searches, I think the simple mysqldump is used. Using mysqldump in Linux to back up a MySQL database as an SQL File Use mysqldump in Linux

When cleaning up unnecessary users after installing MySQL today, I accidentally deleted root @ localhost and added it again. Then I want to add a user to connect to the remote machine, as a result, the user cannot be added. Mysql> select user ();+ --

Source database RHEL4.5: 192.168.137.199 GLOBAL_NAME = WENDING. LK Oracle_SID = WENDING Clone database RHEL4.5: 192.168.137.200 GLOBAL_NAME = STRM. LK ORACLE_SID = STRM 1. Full backup source database $ Sqlplus '/as sysdba' Write down the SCN before

In Oracle 10 Gb, there is a single-Table query SQL statement, which does not have a where clause, but simply calculates the maximum and minimum values of a column at the same time.According to our understanding, it should undergo a full index scan,

Operating System: Oracle linux 6.3 x86_64 Oracle version: Oracle 11.2.0.3 Go to the grid user, cd $ ORACLE_HOM/deinstallE directory [Grid @ xyy1 deinstall] $./deinstallChecking for required files and bootstrapping...Please wait...Location of

Sometimes, we need to connect to the Oracle database through SQL Server to obtain the data of the Oralce database. Instead of program conversion, you can directly create such a link in the SQL Server Enterprise Manager. Step 1: Open SQL server

I have nothing to do with MVCC. I have read a bunch of Chinese on the Internet, and each statement is different. I searched on google and found that there is a description in the MySQL User Guide. I 'd like to translate the original text for

Today, I met a ORA-12154 problem in the group. Here I will record the solution process.The reason is that when a person in the group asks his Windows client to connect to the Oracle server using the easy connect method, the following error is