Database Administrator

There are two types of SQL databases: one is the traditional data table format and the other is the data table format that supports transaction processing (InnoDB, BDB, with InnoDB as the main one ), the following describes how to install and use

1. Install MySQL in Linux The rpm file is a software installation package developed by Red Hat. rpm frees Linux from complicated procedures when installing software packages. The frequently used parameter of this command during installation is-ivh,

I thought that in Linux, ODBC data sources should be created in the same way as in windows. In fact, it is not necessary at all. You can directly connect to Oracle using the JAVA JDBC driver. Use the following statement to load the JDBC driver of

I have been plagued by a problem when I was studying the LAMP environment. That is, if a website contains a database installation page, it must be installed on the host, that is, it must be installed using localhost. My current environment is

After one day of trial, MySQL backup tools in Linux cannot be used for backup. Now we will record the backup steps in detail. Using SQLyogEnt to back up data may cause problems due to a large amount of data, which has caused me many times and is

Installation environment: Linux : Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12.tar.gz/from/pick After decompression, there are five parts. We want to install the workbench. First, download and compile the required

1. query user informationSQL> select username, default_tablespace, temporary_tablespace, created, account_status from dba_users; 2. Add users1.% su-Oracle, or log in with an oracle software installation user2. Change the ORACLE_SID environment

Substr: String truncation function. Substr ($ str, $ start, $ end) If the substr function in MySQL needs to be truncated from the first character, the first parameter should be 1; If the substr function in PHP needs to be truncated from the first

MySQLMain configuration file location:/etc/mysql/my. cnf. Database Table Folder:/var/lib/mysql/, which is equivalent to the date folder of MySQL in Windows in Ubuntu Linux Log on to MySQL and run the encoding: Show variables like 'character % '; + --

Format: grant select on database. * to username @ login host identified by "password" Example 1: Add a user user_britepic whose password is bkjia so that he can log on to any host and have the permission to query, insert, modify, and delete all

After installing phpMyAdmin 3.0, change the name of the config. sample. inc. php file to config. inc. php and edit it in text. Modify the following three parts: $ Cfg ['blowfish _ secret'] = '';/* you must fill in this for cookie auth! */ Just

Use the meb Enterprise Backup Tool to automatically record binary informationThis backup method requires the installation of a software meb, which is installed in the/opt directory by default. The installation process is omitted. Add the following

It is inevitable that dbname and dbid need to be modified during work, such as restoring the database to the same machine. However, dbname and dbid are one of the important symbols used to identify the database, especially dbid, which is unique.

(I) Importance of binary logs If there is data backup at a certain point in time and all binary logs from then on You can replay the binary logs generated since the last full backup and roll back all the changes. (Ii) Best practices for binary log

I learned about Oracle backup today. Alter tablespace users begin backup is executed; Then: Row 3 has an error:ORA-01123: online backup cannot be started; media recovery not enabled It seems that the archive is not started because: In noarchive mode,

Oracle 10 Gb later optimizer supports two modes: normal Mode and tuning mode. In most cases, the optimizer is in normal mode. The CBO-based normal Mode only takes into account a small part of the Execution Plan set to select which execution plan,

"//" Is followed by a comment. "#" indicates the operation under the root user, and "$" indicates the operation under the Oracle user. # Chkconfig iptables off // permanently disable the firewall or # Service iptabels stop // temporarily disable the

Collection of Oracle 11g statistics 1. Do not use the compute and estimate options for ANALYZE. They have been deprecated. In addition, the statistical information collected by analyze cannot be used by the cost-based optimizer and can only be

AsmcmdConnected to an idle instance.Sh:/Oracle/db/product/11g/bin/clsecho: No such file or directory This error is caused by an incorrect environment variable, because I did not create a grid account when installing the grid and directly installed

This article introduces how to install two versions of Oracle Database (oracle 10g/11g) on a host. The system environment uses ol5.8 and uses oracle-validate-rpm to automatically configure the oracle system environment. The installation path needs