Database Administrator

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

Speaking of this problem, I am very ashamed. It was in my previous article "Configuring IP address () in Ubuntu7.10" that solved step 2's problem, this causes the problem that mysql cannot be logged on or cannot be installed again. I apologize to

In Linux, if you attempt to log on to the MySQL Server using the MySQL Adminstrator GUI Tool, the Server returns the following error message: Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to this MySQL server. This is because of

Common pre-defined exceptions of Oralce databases: EXCEPTION WHEN CURSOR_ALREADY_OPEN THEN -- ORA-06511 SQLCODE =-6511 the cursor has been opened WHEN DUP_VAL_ON_INDEX THEN -- ORA-00001 SQLCODE =-1 insert duplicate data into a unique index WHEN

1. Download the corresponding Linux version of Oracle2. Unzip the Installation File: (1) gunzip(2) cpio-idmv 3. Set kernel parameters:(1) Add the following to the/etc/sysctl. conf file: Kernel. shmall = 2097152Kernel. shmmax = 2147483648Kernel.

MySQL commands are also not easy to remember, so it is easy to mess up, and it is impossible to log on to the server by default, You need to authorize the IP address of the desired login machine on the server. Look at the command Mysql> grant all

MySQL is the most popular database system in Linux. Today we will introduce the installation and simple operations of MySQL! Groupadd mysql // create a mysql user groupUseradd-g mysql // create a mysql accountTar-zxvf mysql-x.x.xx.tar.gz //

Backup and restoration of MySQL database in Linux [Root] #/usr/bin/mysqldump-h127.0.0.1-uusername-ppassword databasename>/opt/share/1/backup. SQL /Usr/bin/mysqldump: The program used for execution; -H: Host Name -U: Database User -P: Database

According to several documents on the Internet, finally successfully installed the mysql-5.1.31 in Linux. The Installation Process of Version 5.1 differs from that of the previous version in some details, resulting in installation failure several

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

I used to use MySQL on Linux. for debugging convenience, I installed MySQL Windows 5.6.10 on the development machine. When I used Entity Framework Code First to generate database objects, it is found that the table names of all data tables are

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

I. symptoms: SQL> conn/as sysdba Connected to an idle instance. SQL> startup Oracle instance started. Total System Global Area 276824064 bytes Fixed Size 778736 bytes Variable Size 137371152 bytes Database Buffers 138412032 bytes Redo

Environment: CentOS 6.2 + Oracle 11.2.0.3 1. the Statspack installation and installation process is to create a user perfstat and create corresponding objects under this user. Oracle provides existing scripts to create these objects, we only need to

You need to back up both the cacti-backup. SQL and syslog. SQL databases, and the/var/www/html/folder and its overall content. Restore files and databases: 1. Restore all content in the html folder to the original location: A. decompress the

A high water level line is like a water level line for storing water in a reservoir. It is used to describe the expansion mode of the middle section of the database. The high water level line has a crucial impact on the Full table scan mode. When

Distributed transactions are transactions that occur between multiple databases. Oracle uses the dblink Method for transaction processing. distributed transactions are much more complex than standalone transactions. Most relational databases use the

Always use MySQL 5.0. After a batch of large data tables have been imported recently, the database has become very slow. The reason is that the performance of the InnoDB engine is severely impaired. Then upgrade the database to MariaDB 10.0.2

1: a power outage occurred on the weekend. The newly configured Intranet Test Database active recovery uard environment is automatically disabled. The following error is reported after the master database is started this morning: [Oracle @ db1 ~] $

Environment CentOS 6 x86_64, Oracle 11g R2 Solution Oracle provides dbstart and dbshut scripts in the $ ORACLE_HOME/bin directory to start and stop Oracle. The dbstart script starts the specified database instance and Listener. First,