Database Administrator

You can put this script into crontab and execute it once every morning to automatically back up data.This script can be executed only once a day, and only the backups of the last five days are retained on the server.Note:DumpFile = db $ (date + % y %

Deduplication technology is also called capacity optimization protection technology. What benefits does it bring to customers' computer systems, especially backup systems?At present, the deduplication technology is mainly used for data backup, and

DBWR process: This process writes a buffer into a data file. It is an Oracle background process responsible for Buffer Storage zone management. When a buffer in the buffer zone is modified, it is marked as "dirty". The main task of DBWR is to write

On the OTN, we can see that Oracle 11gR1 for Linux has started to provide download. The initial version is 11.1.0.6.0.Oracle 11g documentation here, the Document Interface layout has been somewhat different from the previous, changed to a layout

The following statements are Mssql statements and cannot be used in access. SQL classification: DDL-Data Definition Language (CREATE, ALTER, DROP, DECLARE)DML-data manipulation language (SELECT, DELETE, UPDATE, INSERT)DCL-Data Control Language

When "blank page" or "mysql extension cannot be loaded, check the PHP configuration, It may be that the php. ini configuration is incorrect, and the error may be as follows: 1. extension_dir = is inconsistent with the actual ext directory of PHP.

MysqlUser = 'root' MysqlPassword ='' Function CheckMysqlPassword () { If [-z $ MysqlPassword] Then CmdResult = 'mysql-u $ MysqlUser-e quit 2> & 1' Else CmdResult = 'mysql-u $ MysqlUser-p $ MysqlPassword-e quit 2> & 1' Fi CmdResultLineCount = 'echo $

In Linux, the script of the system before installing Oracle 10 Gb is the initial prototype. There is no logical relationship. Please use it with caution. #! /Bin/bashCat>/etc/sysctl. conf # Use for oracleKernel. shmall = 2097152Kernel. shmmax = 21474

MySQL has many different forms, at least four different versions: MySQL standard, MySQL Max, MySQL Pro, and MySQL Classic. In addition to the license, MySQL Standard and MySQL Pro are exactly the same. MySQL Standard is registered in GNU Public

1. Install MySQLSudo apt-get install mysql-serverAnd possibly Sudo apt-get install mysq First, use root login to grant permissions to hive users. $ Mysql-u root-p111111Mysql> grant all privileges on *. * TO hive @ localhost identified by "hive123 ";

MYSQL * m_pstConn; // connection to the established MySQL database // Obtain the table name MYSQL_ROW tbl; MYSQL_RES * pResultSet = NULL; PResultSet = mysql_list_tables (m_pstConn, NULL ); While (tbl = mysql_fetch_row (pResultSet )) {Printf ("table:

Permission managementPermission management overviewIn Oracle, user permissions are divided into system permissions and object permissions. System permission: indicates the permission to perform an operation at the database level, such as create

Activity loss or recovery of the Current Log FileOracle ensures that data submitted successfully is not lost through the log file, but in the case of a fault, the user may lose the current log file. this can be divided into two situations: data is

1: How redo log works: Online redo logs store a record of transactions that have occurred in your database. online redo logs exist solely to provide a mechanic for you to recover your database in the event of a failure. you are required to have at

Sorting with the built-in function wm_concat in Oracle When wm_concat is connected to the string, it is found that sometimes it is not sorted according to your requirements. For example, a table named test has the field id, name, product, and

About ALTER TABLE When a table is created, there may be some new requirements during use. In this case, you may need to modify the table structure. If the TABLE has been filled with data, re-creating the TABLE will cause loss of existing data.

Log on to Oracle today and encountered a ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST this problem, the specific solution is as follows: 1. Log On with the sys user SQL> sys/sys as sysdba 2. Check the

Modify the default MySQL engine to innodb. 1. Stop the mysql Service #/Etc/init. d/mysqld stop 2. Back up my. cnf Cd/etc Cp my. cnf my. cnf_bak 3. modify my. cnf [Mysqld] Later # Vi my. cnf Default-storage-engine = InnoDB 4. Delete ib_logfile0 and

SQLite is one of the Top 10 databases in the world. In this article, we performed 10 thousand insert tests on SQLite and MySQL in a transaction. The test result is: "sqlite3 only takes 0.4 s, mysql 2.2 s" IBoxDB is a NoSQL database with SQLite

The Android custom progress bar mainly modifies the style of the ProgressBar, And the pop-up window displays the ProgressBar in the Dialog. Directly add the code. Add the following code to style. xml:   The content of the new