Database Administrator

After MySql is installed, there is only one ROOT user with super management permissions, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? In fact, we need to add a Super User with super

How to use mysql in vc, delphi, vb and other programs (use of mysql odbc driver) We often encounter this problem. How can we use mysql Databases in non-web programs or asp programs? There are two solutions to this problem: 1. Use the api function

As a corporate network manager, I know that website security and access efficiency are important elements related to whether an enterprise can do well. The most important thing is the security of customer data, of course, a good database is

If Oracle 11G reports that Enterprise Manager cannot connect to the database instance, You Can troubleshoot the problem as follows: 1. Use SQL PLUS. Run SQL PLUS in DOS mode. SQL> conn Enter the User name: sys as sysdba Enter the

Synonym CREATE [PUBLIC] SYNONYM synonym For schema. object Hide the Object Name and owner: Select count (*) from hr. employees; Create synonym emp for hr. employees; -- by default, it belongs to the donny user and is the private object of

The MySQL version in Ubuntu 8.04 is 5.0.51a. In the package mysql-server-5.0, not only the Cluster Server Manager (ndb_mgmd) is carried, but also the cluster management client (ndb_mgm ). The client ndb_mgm can be used to display the cluster status,

When I use Webmin (version 1.480) to manage MySQL database servers on the FreeBSD host, the following error occurs: "Warning: Your system has not installed the Perl module DBI and DBD: mysql. Webmin will not be able to access your MySQL database

Performance optimization is a big topic, ranging from program architecture optimization to database design to a specific algorithm or js optimization. Here we will only briefly discuss the performance optimization of hibernate. When using Hibernate,

Practical Environment Introduction: Server Name IP System MySQL Odd.example.com 192.168.1.116 Rhel-5.8 5.5.16 Even.example.com 192.168.1.115 Rhel-5.8 5.5.16 Assume that the database to be

SQL> select * from v $ version; Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-ProdPL/SQL Release 10.2.0.3.0-ProductionCORE10.2.0.3.0ProductionTNS for 32-bit Windows: Version 10.2.0.3.0-ProductionNLSRTL Version

Common scripts:----- Level 1. 0 backupBatch file:Set Oracle_SID = orclRman target sys/test @ orcl prepare file ='s:/backup/scripts/0/db_fullbakup_orcl.rman 'Log ='s:/backup/LOG/rman_backup _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2%. Log' Rman

Note:Oracle Database ServerOperating System: CentOSIP: 192.168.0.198Port 1521SID: orclOracle Database Version: Oracle11gR2 Specific operations: 1. log on to the server as the root user.Mkdir-p/backup/oracledata # create an Oracle Database backup

Common Data Backup Types and toolsMysqldump Backup ToolUse LVM logical volume Snapshot Backup#####################################Common Data Backup Types and tools I won't say much about the importance of data ......, Common Data Backup types are

Create a Data Group All group functions treat the table as a large information group. However, you sometimes need to divide the table into several smaller groups. You can use the group by clause to complete this task. Create a Data GROUP: group

A sequence is a database object used to create an integer. You can create a sequence and use it to generate numbers. Sequence has the following features: • A Unique id can be automatically generated • It is a shared object • It can be used to create

There is a mature built-in row-to-column function in Oracle, and ipvs also has such an application named tablefunc.This Pg application is not installed by default during installation. If it is already installed, three tablefunc * files are available

Because the addition, deletion, and modification of the MySQL database suddenly increase, the operations on the tables that need to be queried are very frequent. I wrote a small tool to analyze the bin-log and find the tables for addition, deletion,

1. Preface Recently, I have been studying MongoDB. I have learned a lot about data modification and complicated commands. So I will summarize some frequently used modification commands in this blog to facilitate future study. 2. Command Summary 1).

When I clone a database, the following error occurs at the source option: Solution: run $ Oracle_HOME/root again. sh to solve the problem. because the root is executed during database installation. sh. It is suspected that the re-execution of root

The process of using rman duplicate to create a slave database is much simpler. You do not need to manually create a slave Database Control File. Master database SPFILE *. Log_archive_format = '% T % S % r. arc'*. DB_UNIQUE_NAME = 'primary'*.