Database Administrator

This article summarizes many common MySQL commands on the network and describes the process in detail. 1. Connect to MySQL Format: mysql-h host address-u user name-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the

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

MySQL has a lot of basic commands, and the show command is also one of them. In many users, the use of the show command is also prone to confusion. This article summarizes the many usage of the show command.A. show tables or show tables from

When you connect to a MySQL server, you should usually use a password. The password is not transmitted in plain text on the connection. All other information is transmitted as text that can be read by anyone. If you are worried about this, you can

Yesterday BitTorrent announced the closure of source code, and today's famous database software MySQL also announced the closure of source code.MySQL has announced that it is about to shut down the source code of the MySQL Enterprise Server. This

The main reason is that the Code in Hacking Linux Network Stack was not compiled in 2.6.22 yesterday and the member nh cannot be found, I guess the struct must have changed. Check/include/linux/skbuff. h and find that the original combination of h,

How to start MySQL in Linux: (this document uses the installation of MySQL in/usr/local/mysql as an example)#/Usr/local/mysql/share/mysql. server startNote that before the first execution, mysql. server to be executable (chmod 744 mysql. server). In

I. Formal method (officially recommended by mysql ):MySQL mysqldump is used for export. The basic usage is as follows:Mysqldump [OPTIONS] database [tables]If you do not specify any tables, the entire database will be exported.Run mysqldump -- help

OpenSER homepage: http://www.openser.org Download: http://www.openser.org/pub/openser/latest-1.2.x/src/openser-1.2.2-tls_src.tar.gz Preparation Test Platform for Fedora8, pre-installed MYSQL-5.0.45; Need to install the corresponding MySQL-devel-5.0.4

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

1. First, check the name and file of the tablespace. Select tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) total_spacefrom dba_data_filesorder by tablespace_name; 2. Add data files Alter tablespace users add datafile

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 ";

We all know that Oracle will automatically handle deadlocks without human intervention, but Oracle cannot handle session blocking on its own. Blocking leads to resource waste and system performance consumption, at this time, we need to quickly find

If the Linux Kernel Parameter settings are inappropriate or unreasonable, Oracle may also encounter errors, such10 GB:SQL> startup;ORA-27102: out of memoryLinux-x86_64 Error: 28: No space left on device11g RAC error:SQL> startup;ORA-00845:

The processing logs cannot be retained on site, and the logs are written in memory. Give yourself a thought prompt. When a development database is started, an undo error is reported. The environment is Oracle 10.2.0.5 and aix 5308. Start the

# Creating a database Create database why; # Creating a user table Create table why (employee_id bigint, name char (16), gerder enum ('M', 'F'), dept_id enum ('caiwu', 'renshi ', 'shichang ', 'jishu'), join_time date, salary double, phone char (11),

Because after Oracle shares the SQL statements, the intercepted SQL statements contain variables. Create a function jy_getsql to obtain the complete SQL statement during execution. Create or replace function jy_getsql (my_ SQL _id in

Premise: the master-slave structure is in place, and the master database is not configured with persistence. Configure AOF from the slave database. (The master database is used for backup and write services, and the slave database is used to provide

Oracle 11.2 instant client installation in RHEL5.6 Download the installation file as needed: I only need two files: oracle-instantclient11.2-basic.rpm and sqlplus. rpm. View the path information in the rpm: Rpm-qpl download rpm package name