NAV: SLTechnology News&Howtos > Database >

• 

  MS SQL Server database content batch with the same data table name between two libraries

  The previous article, "Export record quantity comparison-Software testing method (1)", mainly introduced the accurate comparison between the number of records of data export results and the number of records of the original normal database, and the relevant bug of less data exported by test software. The purpose of this test method is to compare the internal data differences of table records and the number of records more accurately.

  2022-06-01 18:23:01 Views: 295
• 

  VEEAM9.5 Oracle 11g Windows backup and restore manual

  This manual is limited to VEEAM Backr backup Oracle 11g scenarios. 1. Start check VEEAM service status Veeam Backup Service service VeeamBrokerSvc service Veeam Cloud Con

  2022-06-01 18:22:30 Views: 239
• 

  Mysql related operations

  Backup database mysqldump-uroot-p abc > abc.sql import database mysql-uroot-p abc < abc.sql create database and make it support Chinese create database

  2022-06-01 18:22:30 Views: 229
• 

  Do not install Oracle locally, use plsql to connect to the database remotely

  (1) do not install Oracle,plsql remote connection database locally. 1. First go to the Oracle website to download Instant Client: http://www.oracle.com/us/solutions/index-0

  2022-06-01 18:22:30 Views: 258
• 

  OGG operation and maintenance optimization script (20)-process operation class-forced time point adjustment

  File name: fullrestart.sh path $HOME/ggscript/ggoperat this script is specially written to deal with the frequent delay of OGG, a very troublesome business database server, because this database calls large every night.

  2022-06-01 18:22:30 Views: 228
• 

  UniDAC usage tutorial (3): master-slave relationship

  Download the latest version of UniDAC Universal Data Access Components (UniDAC) is a general database access component that provides direct access to multiple databases, such as Delphi for Windows, C

  2022-06-01 18:22:25 Views: 223
• 

  The essence of data work: from the business to the business

  Introduction: data work is relatively simple in terms of composition structure and process, because the work is already very young and the division of labor is not very detailed. Generally speaking, I regard data work as three interconnected parts: taking numbers, rational numbers, and using numbers, which is a closed loop. The need to use numbers will drive the work of fetching numbers, and fetching

  2022-06-01 18:22:25 Views: 215
• 

  Mysqldump of MySQL5.6 backup (1)

  Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS]-databases [OPTIONS] DB1 [DB2 DB3

  2022-06-01 18:22:25 Views: 290
• 

  The MySQL5.6 of the question rose by 5.7.

  Problem 1: solution: there is a pre-upgrade original version in the PATH environment. If you change the PATH variable, you can note that when the soft connection is deleted, rm-rf mysql rather than rm-rf mysql/, will delete the original file. Problem 2: 5

  2022-06-01 18:22:15 Views: 202
• 

  Oracle 12.1.02 CRS call completion waiting event BUG encountered by Taiwan compatriots

  Recently, I helped a good friend deal with a database system performance problem. After analyzing the awr report and looking at the official documents, I found a 12.1.0.2 bug, which happened to be in service for the customer, opened SR, and the official reply confirmed the problem. To install this version of the production system, you can set the relevant parameters (

  2022-06-01 18:22:09 Views: 227
• 

  MongoDB master-slave + php implementation

  Environment 172.16.115.202 primary172.16.111.171 secondary172.16.115.157 secondary 1, MongoDB installation 1. Yum download and install mongodb

  2022-06-01 18:21:39 Views: 294
• 

  MyCat realizes the code of read-write separation, sub-library and global table.

  The environment is as follows: system IP hostname service Centos 7.5192.168.20.2mysql01MySQL 5.7.24Centos 7.5192.168.20.3mysql02MySQL 5.7.24Cent

  2022-06-01 18:21:39 Views: 280
• 

  Redis profile parameter description

  Redis configuration file parameter description 1. Redis does not run as a daemon by default, but can be modified by this configuration item to enable the daemon daemonize no2. When Redis runs as a daemon, Redis defaults to p

  2022-06-01 18:21:39 Views: 237
• 

  AIX system Learning-Software error after system upgrade

  AIX system Learning-Software errors after system upgrade system Environment: operating system: AIX 5.3.8Oracle: Oracle 11gR2 case study: after upgrading AIX5.3 from 5300-08 to 5300-09, install Oracle 1 directly

  2022-06-01 18:21:38 Views: 245
• 

  Using DataNucleus to connect Hbase

  Exit safemode mode and run the program DataNucleus is a middleware that implements the jpa interface, which makes it easy to connect to Hbase and map entity classes in model (@ Entity,@Id … ), conducted by dataNucleus

  2022-06-01 18:21:17 Views: 218
• 

  Common errors in Oracle

  Oracle11G error ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop

  2022-06-01 18:21:14 Views: 282
• 

  A failed experience of mongodb's wildcard query

  I want to find to the movie name field under the nested sub-json under the synonym_titles in mongo or the movie name field under the nested sub-json under real_titles: but the info information field of 1-line 2 is uncertain, so I want to do this.

  2022-06-01 18:21:14 Views: 250
• 

  CentOS 6.5 minimize compilation install mysql 5.5.35 configure multiple instances

  CentOS 6.5 minimize compilation installation mysql 5.5.35 configure multiple instances 1, turn off the firewall [root@mysql ~] # service iptables stopiptables: Setting chai

  2022-06-01 18:21:13 Views: 302
• 

  How to install and deploy MyCat

  How to install and deploy MyCat? I believe that most people have not learned how to install deployment, in order to let you learn, to give you a summary of the following, do not say much, let's look down together 1, prepare mycat deployment environment system IP hostname service Centos 7.5192.168.

  2022-06-01 18:21:13 Views: 271
• 

  The new version of mysqlroot cannot log in. Set a new password after mysql access without a password.

  1. Add a line in / etc/my.cnf to save skip-grant-tables and exit 2. Enter directly enter mysql4 mysqld restart3,mysql-uroot-p and enter u after login

  2022-06-01 18:21:12 Views: 216