Database Administrator

Perform the following steps when configuring MySQL in Linux: 1. Download and install rpm. Problem: After the server is installed, an error occurs when you enter the mysql Command, and no mysqladmin is found under/usr/bin/when you change the password.

(1) log on with the system root permission (2) Stop the MYSQL server: Mysqladmin shutdown (3) skip the authorization table and execute the MYSQL server: Mysqld_safe -- skip-grant-tables -- skip-networking & (Note: The parameter --

When using MySQL for database restoration, The following Error occurs due to The large data size: The MySQL Server returned this Error: MySQL Error Nr.2006-MySQL server has gone away. This error occurs when I restore a MB backup. The solution is to

By default, remote control is not enabled for MySQL. Users with remote access must be added. if the version is installed, log on to the console provided by MySQL. Log On with the root user, and then: Grant all privileges on *. * to create the

If you want to write Perl scripts that can access the MySQL database, you need to install the DBI module. You need to install two groups of DBI modules, one of which is the DBI module that provides various basic DBI drivers, another group is the DBD:

Oracle Version: Oracle10.2.0.1 Author: Cocis When creating a user in a database, it is best to create an independent tablespace for different users based on application performance and management considerations. 1. Create a tablespace In both the

Mysqld_safe supports the following options: -- Help Displays help information and exits. -- Autoclose On the NetWare system, mysqld_safe provides a screen display. When we transport (disable) mysqld_safe NLM, the screen will not disappear by default.

I. Overview The company has purchased a new batch of PCs and is ready to upgrade several better-performing PCs to database servers to replace old machines. The company has a set of POS terminal software, and the background data storage is MySQL 3.23.

Huang.bin.cn@live.cn original, reproduced please indicate the source. For more information about the installation process, refer to many articles on the Internet.--------------------------------------------------------HOST: ThinkPad T400Memory: 1024

In fact, for a small DBA, sometimes these problems cannot be avoided. Therefore, we need a tool to check whether the master-slave replication is normal and whether an error has occurred. Pt-table-checksum. MySQL 5.6 master-slave replication Part 1

Oracle 11g allows the index to be marked as invisible. oracle maintains the invisible index like other indexes, but the default invisible index cannot be used by the optimizer unless OPTIMIZER_USE_INVISIBLE_INDEXES = TRUE is explicitly set (you can

Creating databases, tables, and query statements in MySQL will be of great help to our application databases in the future. This article summarizes these basic statements, I hope to help you. 1. Create and delete databases. Create a database

Install MySQL 5.1.62 in Ubuntu source code (for your reference only) The simplest and most straightforward way to install a database in ubuntu is to run the following command: sudo apt-get install mysql-server. However, this method often encounters

Oracle has three table connection technologies: Nested connection, merge connection, and hash connection. 1. nested loop Join) Nested connection divides the dataset to be processed into an External Loop (driving data source) and an internal loop

An error occurred in the alter log of the backup database on site.ORA-1688: unable to extend table SYS. WRH $ _ SQLSTAT partition WRH $ _ SQLSTA_3344221469_3956 by 128 in tablespace SYSAUXORA-1688: unable to extend table SYS. WRH $ _ SQLSTAT

The procedure for Oracle partition switching is as follows: 1. Create Partition Table t1. Assume that there are two partitions, P1 and P2.2. Create a base table t11 to store data of the P1 rule.3. Create a base table t12 to store P2 rule data.4. Use

Today, my friend asked a particularly tangled question: In a table in the database, the table duplicates a field in the table and sorts the remaining data according to another field, Create a table as follows: Create table TEST_DISTINCT (ID integer

This article describes the usage of Oracle analysis functions. First, create a database: Create table earnings(Earnmonth varchar2 (6), -- month of workArea varchar2 (20), -- working areaSno varchar2 (10), -- employee IDSname varchar2 (20), -- name

When I inserted data into the experiment environment, I finally broke up with ASM.In ASMCA, the available space is-0.04 GB.At this time, shutdown abort, and then start, it can only be in the mount state, as long as one open, WillORA-03113:

References (1) official SUSE installation documentation: Oracle database on SLES11 SP2 (PDF) (2) Oracle Online Book: Database Quick Installation Guide for Linux x86-64 Free in http://linux.bkjia.com/(Note: This address is not FTP, directly click to