Database Administrator

The Helper house sorted out several methods circulating on the Internet to crack the mysql root Password: Method 1 Use phpmyadmin, which is the simplest. Modify the user table of the mysql database, but do not forget to use the PASSWORD

How to download and install PostgreSql in Linux: [Merge multiple objects to append][Root @ localhost ~] # Useradd S[Root @ localhost ~] # Passwd ipvs【PostgreSQLPlease refer to the following link for more information][Root @ localhost ~] #

MySQL suddenly becomes unavailable. In the end, it is found that there is no space for/var in Linux, and the usage rate is 100%. No way, you can only move the database file to another partition. After moving the data file to another partition in

Installation environment: VMware Workstation 5.5.3 Host hardware environment: AthlonXP 2000 +, 256*2/DDR400, ST80G, GeForce4 MX440 Select Other Linux 2.6.x for Linux created using VM After installation, the virtual machine environment is as

After installing the Oracle database in Linux, I tried to use dbstart to start the database but did not respond. In this case, I need to change the oracle configuration. Su rootVi/etc/oratab*:/Opt/oracle/product/9.2.0.4: NEgo:/opt/oracle/product/9.2.

Sometimes the database is damaged due to power loss or other reasons. We can use the MySQL command to quickly fix all databases or specific databases. For example Check to optimize and fix all databases: # Mysqlcheck-A-o-r-pEnter password:Database1

I am a beginner in Linux and have trouble installing PostgreSQL today. I need to install PostgreSQL8.2 now, but enter the command in the console: emerge PostgreSQL-pv to search for only PostgreSQL8.0. However, I need to install version 8.2, what

INSTALL the MySQL BINARY package according to the INSTALL-BINARY instructions. problems may occur in RedHat Linux. Other releases are not tested. Many people on the Forum are looking for a solution, I have an incorrect answer before, and I want to

1. Configuration:./Configure \-- Prefix =/home/zengyf/local/mysql-5.1.30 \-- Enable-local-infile \-- With-unix-socket-path =/home/zengyf/local/mysql-5.1.30/var/mysql. sock \-- With-tcp-port = 5506 \-- Enable-thread-safe-client \-- With-mysqld-user =

It is useful for configuring MySQL Databases today. Download the latest phpMyAdmin MYSQL manager, Decompress the package and obtain a phpMyAdmin directory (you can change the name to ensure security, otherwise your FTP password must be strong) Find

Rchive log is fullORA-00257: How to Handle archiver error. Connect internal only, until freed error 1. Log On with the sys userSqlplus sys/pass @ tt as sysdba 2. Check the location of the archiv log.SQL> show parameter log_archive_dest;NAME TYPE

The official MySQL 5.6 version has been released. Compared with MySQL 5.5, the source code installation and configuration methods have also changed. Based on actual operations, this article continuously attempts to precisely restore the installation

Problem description: The operating system of the server is CentOS 5.5. Many systems have been running on the server and PHP5.2.10 is installed. The stable yum installation source version of Centos5.X is 5.1.6 and does not comply with the latest

(1) lower_case_table_names ● Recommendation reason The GNU/Linux platform is case sensitive to names of databases, tables, stored procedures, and other objects. To reduce developer development costs, we recommend that you set this parameter so that

About setting the table to read only in Oracle Alter table test3 read only; This feature should be added from 11 GB, because an error is reported when it is executed in 10 GB: ORA-01735: Invalid alter table Option After the value is set to read

Summarize and organize yourself: 1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct; 2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for

When to use B + tree indexes Not all columns that appear under all query conditions need to be indexed. When to add B + tree indexes, my experience is that it makes sense to use B + tree indexes to access a small part of a table. For gender fields,

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start. Database Version: 10.2.0.1.0 [Oracle @ hhserverfs ~] $ Sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Sat Jun 8 11:46:38 2013

Environment setup Machine descriptionMaster 190: 192.168.1.190 (enable binlog, server-id = 1)Slave 191: 192.168.1.191Slave 192: 192.168.1.192MySQL 5.5.29 and Percona XtraBackup 2.06 are installed on all the above three machines. Create a new Slave

It's not really good to read the doc carefully. SQL> shutdown immediateThe database has been closed.The database has been detached.The Oracle routine has been disabled.SQL> startup mountThe ORACLE routine has been started. Total System Global Area 10