在达梦中如何删除数据文件？
Kubee 2021-11-12 13:43 1453 1
DM-单个表空间容量限制255个数据文件，TS_FIL_MAX_ID 这个参数是否可修改？
Kubee 2021-10-18 09:16 1567 3
问题描述： 应用连接oracle数据库服务超时： 2021/9/xx 上午xx:xx:xx### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms. 数据库分析： 1.sqlplus登入数据库成功； 2.监听状态正常； 3.alert.log无报错； 4.pc客户端连接工具navicat&plsql连接数据库成功； 5.应用服务器telnet 数据库服务器ip port，网络正常 重启应用，刚开始3-5分钟应用能正常使用，超过一定时间应用报错数据库连接超时，应用不可用； 重启数据库，应用恢复正常；
xum 2021-09-23 14:24 1983 2
更新插件的方法有哪些？
Kubee 2021-09-17 09:42 1535 0
请问各位有人使用Xshell+Disql工具连接达梦8数据时出现键盘上、下、左、右键失效的情况么？ 如下图： 单独使用Xshell工具是好的，进入Linux后使用Disql也是好的，当使用Xshell+Disql时会出现上述问题。 请大神帮忙解释一下，谢谢！！！
sdrlilei 2021-07-23 09:32 1701 1
x_123 2021-06-26 00:57 1226 1
使用源码编译安装mariaDB时使用的cmake参数中有个-DWITH_ARCHIVE_STPRAGE_ENGINE=1的参数是什么意思？在网上查了半天没有找到。
CY 2021-03-09 16:47 1310 1
公司之前在用VMware vsphere软件，有没有类似的国产替代软件？
mnlin 2021-03-03 14:01 1226 1
哪位有oracle账号的同学，帮忙查一下： Doc ID 1940500.1 万分感谢！
justin764 2021-01-22 17:47 1325 3
环境： 当前RAC里有2个节点erpdb61、erpdb62，准备添加第三个节点erpdb67，三个节点已经配置完ssh互信、hosts等其他系统参数 第一次在第一个节点进行clufy预检查的时候发现节点3的2个网卡名称跟其他2个节点不一样，然后修改节点3的网卡、重启系统后网卡名称已经与其他2个节点一致 以下是3个节点的hosts文件 #public ip 192.168.2.61 erpdb61 192.168.2.62 erpdb62 192.168.2.67 erpdb67 #private ip 10.10.20.61 erpdb61priv 10.10.20.62 erpdb62priv 10.10.20.67 erpdb67priv #vip 192.168.2.63 erpdb61vip 192.168.2.64 erpdb62vip 192.168.2.68 erpdb67vip #scan ip 192.168.2.65 erpdbscan 以下是节点1的网卡ip信息： [root@erpdb61 ~]# ip a 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:a9:c6:ee brd ff:ff:ff:ff:ff:ff inet 192.168.2.61/24 brd 192.168.2.255 scope global noprefixroute ens33 valid_lft forever preferred_lft forever inet 192.168.2.65/24 brd 192.168.2.255 scope global secondary ens33:1 valid_lft forever preferred_lft forever inet 192.168.2.63/24 brd 192.168.2.255 scope global secondary ens33:3 valid_lft forever preferred_lft forever inet6 fe80::e9d6:dbf7:6ed8:39ad/64 scope link noprefixroute valid_lft forever preferred_lft forever 3: ens34: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:a9:c6:f8 brd ff:ff:ff:ff:ff:ff inet 10.10.20.61/24 brd 10.10.20.255 scope global noprefixroute ens34 valid_lft forever preferred_lft forever inet 169.254.162.237/16 brd 169.254.255.255 scope global ens34:1 valid_lft forever preferred_lft forever inet6 fe80::5a4c:53e:5ee:6c37/64 scope link noprefixroute valid_lft forever preferred_lft forever 4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000 link/ether 52:54:00:6f:b8:54 brd ff:ff:ff:ff:ff:ff inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0 valid_lft forever preferred_lft forever 5: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN group default qlen 1000 link/ether 52:54:00:6f:b8:54 brd ff:ff:ff:ff:ff:ff 以下是节点2的网卡ip信息： [root@erpdb62 ~]# ip a 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:4f:23:8e brd ff:ff:ff:ff:ff:ff inet 192.168.2.62/24 brd 192.168.2.255 scope global noprefixroute ens33 valid_lft forever preferred_lft forever inet 192.168.2.64/24 brd 192.168.2.255 scope global secondary ens33:1 valid_lft forever preferred_lft forever inet6 fe80::eb56:893e:3ba7:2285/64 scope link noprefixroute valid_lft forever preferred_lft forever 3: ens34: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:4f:23:98 brd ff:ff:ff:ff:ff:ff inet 10.10.20.62/24 brd 10.10.20.255 scope global noprefixroute ens34 valid_lft forever preferred_lft forever inet 169.254.68.255/16 brd 169.254.255.255 scope global ens34:1 valid_lft forever preferred_lft forever inet6 fe80::daa9:74b4:7bbd:461f/64 scope link noprefixroute valid_lft forever preferred_lft forever 4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000 link/ether 52:54:00:1b:57:dd brd ff:ff:ff:ff:ff:ff inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0 valid_lft forever preferred_lft forever 5: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN group default qlen 1000 link/ether 52:54:00:1b:57:dd brd ff:ff:ff:ff:ff:ff 以下是节点3的网卡ip信息： [root@erpdb67 ~]# ip a 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:df:61:42 brd ff:ff:ff:ff:ff:ff inet 192.168.2.67/24 brd 192.168.2.255 scope global ens33 valid_lft forever preferred_lft forever inet6 fe80::20c:29ff:fedf:6142/64 scope link valid_lft forever preferred_lft forever 3: ens34: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000 link/ether 00:0c:29:df:61:4c brd ff:ff:ff:ff:ff:ff inet 10.10.20.67/24 brd 10.10.20.255 scope global ens34 valid_lft forever preferred_lft forever inet6 fe80::20c:29ff:fedf:614c/64 scope link valid_lft forever preferred_lft forever 4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default qlen 1000 link/ether 52:54:00:96:c8:6d brd ff:ff:ff:ff:ff:ff inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0 valid_lft forever preferred_lft forever 5: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN group default qlen 1000 link/ether 52:54:00:96:c8:6d brd ff:ff:ff:ff:ff:ff 再次进行检查的时候，结果如下： [grid@erpdb61:/home/grid]$cluvfy stage -post hwos -n erpdb67 -verbose Performing post-checks for hardware and operating system setup Checking node reachability... Check: Node reachability from node "erpdb61" Destination Node Reachable? ------------------------------------ ------------------------ erpdb67 yes Result: Node reachability check passed from node "erpdb61" Checking user equivalence... Check: User equivalence for user "grid" Node Name Status ------------------------------------ ------------------------ erpdb67 passed Result: User equivalence check passed for user "grid" Checking node connectivity... Checking hosts config file... Node Name Status ------------------------------------ ------------------------ erpdb67 passed Verification of the hosts config file successful Interface information for node "erpdb67" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ ens33 192.168.2.67 192.168.2.0 0.0.0.0 UNKNOWN 00:0C:29:DF:61:42 1500 ens34 10.10.20.67 10.10.20.0 0.0.0.0 UNKNOWN 00:0C:29:DF:61:4C 1500 virbr0 192.168.122.1 192.168.122.0 0.0.0.0 UNKNOWN 52:54:00:96:C8:6D 1500 Check: Node connectivity for interface "ens33" Result: Node connectivity passed for interface "ens33" Check: TCP connectivity of subnet "192.168.2.0" Source Destination Connected? ------------------------------ ------------------------------ ---------------- erpdb61:192.168.2.61 erpdb67:192.168.2.67 passed Result: TCP connectivity check passed for subnet "192.168.2.0" Check: Node connectivity for interface "ens34" Result: Node connectivity passed for interface "ens34" Check: TCP connectivity of subnet "10.10.20.0" Source Destination Connected? ------------------------------ ------------------------------ ---------------- erpdb61:192.168.2.61 erpdb67:10.10.20.67 failed ERROR: PRVF-7617 : Node connectivity between "erpdb61 : 192.168.2.61" and "erpdb67 : 10.10.20.67" failed Result: TCP connectivity check failed for subnet "10.10.20.0" Result: Node connectivity check failed Checking multicast communication... Checking subnet "192.168.2.0" for multicast communication with multicast group "230.0.1.0"... Check of subnet "192.168.2.0" for multicast communication with multicast group "230.0.1.0" passed. Checking subnet "10.10.20.0" for multicast communication with multicast group "230.0.1.0"... Check of subnet "10.10.20.0" for multicast communication with multicast group "230.0.1.0" passed. Check of multicast communication passed. Checking for multiple users with UID value 0 Result: Check for multiple users with UID value 0 passed Check: Time zone consistency Result: Time zone consistency check passed Checking shared storage accessibility... Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sda erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdb erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdc erpdb67 /dev/sde erpdb67 /dev/sdh erpdb67 /dev/sdl erpdb67 /dev/mapper/fs-backup01 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdd erpdb67 /dev/sdg erpdb67 /dev/sdj erpdb67 /dev/sdm erpdb67 /dev/mapper/fs-backup02 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdf erpdb67 /dev/sdi erpdb67 /dev/sdk erpdb67 /dev/sdo erpdb67 /dev/mapper/fs-backup03 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdn erpdb67 /dev/sdq erpdb67 /dev/sdw erpdb67 /dev/sdab erpdb67 /dev/mapper/asm-dggrid1 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdp erpdb67 /dev/sds erpdb67 /dev/sdz erpdb67 /dev/sdaf erpdb67 /dev/mapper/asm-dggrid2 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdr erpdb67 /dev/sdu erpdb67 /dev/sdac erpdb67 /dev/sdai erpdb67 /dev/mapper/asm-dggrid3 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdt erpdb67 /dev/sdx erpdb67 /dev/sdag erpdb67 /dev/sdan erpdb67 /dev/mapper/asm-dggrid4 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdv erpdb67 /dev/sdaa erpdb67 /dev/sdak erpdb67 /dev/sdar erpdb67 /dev/mapper/asm-dggrid5 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdy erpdb67 /dev/sdae erpdb67 /dev/sdao erpdb67 /dev/sdav erpdb67 /dev/mapper/asm-dggrid6 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdad erpdb67 /dev/sdaj erpdb67 /dev/sdau erpdb67 /dev/sdaz erpdb67 /dev/mapper/asm-dgsystem01 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdah erpdb67 /dev/sdal erpdb67 /dev/sdaw erpdb67 /dev/sdbd erpdb67 /dev/mapper/asm-dgrecovery01 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdam erpdb67 /dev/sdaq erpdb67 /dev/sdbc erpdb67 /dev/sdbe erpdb67 /dev/mapper/asm-data01 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdap erpdb67 /dev/sdat erpdb67 /dev/sdbg erpdb67 /dev/sdbi erpdb67 /dev/mapper/asm-data02 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdas erpdb67 /dev/sday erpdb67 /dev/sdbh erpdb67 /dev/sdbj erpdb67 /dev/mapper/asm-data03 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdax erpdb67 /dev/sdba erpdb67 /dev/sdbk erpdb67 /dev/sdbl erpdb67 /dev/mapper/asm-dgsystem02 erpdb67 Disk Sharing Nodes (1 in count) ------------------------------------ ------------------------ /dev/sdbb erpdb67 /dev/sdbf erpdb67 /dev/sdbm erpdb67 /dev/sdbn erpdb67 /dev/mapper/asm-dgrecovery02 erpdb67 Shared storage check was successful on nodes "erpdb67" Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ... Checking if "hosts" entry in file "/etc/nsswitch.conf" is consistent across nodes... Checking file "/etc/nsswitch.conf" to make sure that only one "hosts" entry is defined More than one "hosts" entry does not exist in any "/etc/nsswitch.conf" file Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed Post-check for hardware and operating system setup was unsuccessful on all the nodes. 检查失败：Check: TCP connectivity of subnet "10.10.20.0" Source Destination Connected? ------------------------------ ------------------------------ ---------------- erpdb61:192.168.2.61 erpdb67:10.10.20.67 failed ERROR: PRVF-7617 : Node connectivity between "erpdb61 : 192.168.2.61" and "erpdb67 : 10.10.20.67" failed Result: TCP connectivity check failed for subnet "10.10.20.0" 这个问题我有点搞不懂了，为什么erpdb61用public ip去跟erpdb67的private ip进行测试呢？ 这2个IP不在同一个网段啊
ME_infinite 2020-02-28 11:06 4046 1
数据库版本:11.2.0.4.0， 操作系统版本centos 7.4版本。共享存储，心跳网线直连两台服务器。 rac 集群中，节点2总是被集群踢出，查看数据库实例2，也是down状态，节点1可以供服务，不知道什么问题导致。报错如下:
yrq_2020 2020-02-17 19:05 4033 0
使用ogg 实时同步oracle数据到pg ogg连接pg时候报错 错误信息： GGSCI (rac1) 3> dblogin sourcedb oggtest userid ogg Password: 2019-07-30 09:40:27 WARNING OGG-00552 Database operation failed: Couldn’t connect to oggtest. ODBC error: SQLSTATE IM002 native database error 0. [DataDirect][ODBC lib] Data source name not found and no default driver specified. ERROR: Database operation failed: Couldn’t connect to oggtest. ODBC error: SQLSTATE IM002 native database error 0. [DataDirect][ODBC lib] Data source name not found and no default driver specifiedFailed to open data source oggtest for user ogg. 相关的资料也都查了，无法解决 export LD_LIBRARY_PATH=/opt/postgres/soft/lib:/opt/postgres/ogg/lib export ODBCINI=/opt/postgres/ogg/odbc.ini 想知道这块怎么设置，网上资料太少了
Jason Tao 2019-07-30 21:50 5318 1
公司数据库的trace文件持续增长，每天增加3G，在日志文件中报错，如下： <msg time='2019-03-28T23:59:24.351+08:00' org_id='oracle' comp_id='rdbms' msg_id='2817635650' type='INCIDENT_ERROR' group='Generic Internal Error' level='1' host_id='abasvr1' host_addr='10.200.0.51' pid='47648' prob_key='ORA 600 [qctbyt : bfc]' errid='224872' detail_path='/u01/app/oracle/diag/rdbms/tscdb/tscdb1/trace/tscdb1_j001_47648.trc'> <txt>Errors in file /u01/app/oracle/diag/rdbms/tscdb/tscdb1/trace/tscdb1_j001_47648.trc (incident=224872): ORA-00600: internal error code, arguments: [qctbyt : bfc], [4000], [12000], [1], [873], [1], [1], [0], [], [], [], [] </txt> </msg> <msg time='2019-03-28T23:59:24.356+08:00' org_id='oracle' comp_id='rdbms' msg_id='dbgexProcessError:1321:3370026720' type='TRACE' level='16' host_id='abasvr1' host_addr='10.200.0.51' pid='47648'> <txt>Incident details in: /u01/app/oracle/diag/rdbms/tscdb/tscdb1/incident/incdir_224872/tscdb1_j001_47648_i224872.trc </txt> </msg> 这个问题出现好久了，对于数据库运行也没特别大的影响，但是每天生成3G的追踪文件还是觉得有点恐怖啊，求大神指点 此问题根据oracle官方文档介绍，是oracle12c的一个bug,需要打一个补丁包，是我没有测试，仅供参考
jimmy 2019-06-05 10:47 4349 1
各位好： 我在 CentOS 7.2 x86_64 系统试过分别安装 5.7.25 和 5.7.19 版本的Linux通用二进制 mysql 社区版都碰到如下 my.cnf 配置文件中 [client]和[mysql] 配置域不生效的问题，比如 socket 和 prompt(SQL提示符格式)都不生效， 查过目录权限没问题和 my.cnf 文件也只有这一个，而且 [mysqld] 服务器域的配置是生效的。 具体如下： 1、/usr/local/mysql/my.cnf 配置文件如下： [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3309 socket = /usr/local/mysql/mysql.sock character_set_server = utf8 server_id = 1 log_bin = /usr/local/mysql/log/mysql-bin query_cache_type = 2 [client] port = 3309 socket = /usr/local/mysql/mysql.sock [mysql] port = 3309 socket = /usr/local/mysql/mysql.sock prompt = "//u@//d*//h //R://m://s >" 2、并且指定了 defaults-file=/usr/local/mysql/my.cnf 启动项： [root@centos-mysql mysql]# mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql & [1] 5151 [root@centos-mysql mysql]# 2019-03-19T12:56:31.135298Z mysqld_safe Logging to '/usr/local/mysql/data/centos-mysql.err'. 2019-03-19T12:56:31.164697Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data [root@centos-mysql mysql]# ps -ef | grep mysql avahi 692 1 0 19:02 ? 00:00:00 avahi-daemon: running [centos-mysql.local] root 5151 4784 0 20:56 pts/2 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql mysql 5340 5151 2 20:56 pts/2 00:00:00 /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=centos-mysql.err --pid-file=centos-mysql.pid --socket=/usr/local/mysql/mysql.sock --port=3309 3、以上 my.cnf 配置文件中，已经指定了 socket 连接符文件配置项的，但登录时还是要指定，如不指定，会默认读取 /tmp/mysql.sock 这个socket连接文件，如下： [root@centos-mysql mysql]# mysql -uroot -pcaserver mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 4、遍历整个系统全盘目录，就只有我配置的这个 my.cnf 文件，不存在多个 my.cnf 配置文件覆盖参数的问题，如下： [root@centos-mysql mysql]# find / -name "my*.cnf" /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64/my.cnf find: ‘/run/user/42/gvfs’: Permission denied [root@centos-mysql mysql]# find / -name ".my*.cnf" ##文件名加.的隐藏文件也查了，也没有 find: ‘/run/user/42/gvfs’: Permission denied 5、查 mysql 目录，权限都正常，并且 mysql.sock 连接文件也能正常生成，如下： [root@centos-mysql mysql]# ls -ltr total 72 -rw-r--r-- 1 mysql mysql 2478 Jun 22 2017 README -rw-r--r-- 1 mysql mysql 17987 Jun 22 2017 COPYING drwxr-xr-x 3 mysql mysql 4096 Mar 19 20:40 include drwxr-xr-x 4 mysql mysql 4096 Mar 19 20:40 man drwxr-xr-x 2 mysql mysql 4096 Mar 19 20:41 bin drwxr-xr-x 5 mysql mysql 4096 Mar 19 20:41 lib drwxr-xr-x 2 mysql mysql 4096 Mar 19 20:41 support-files drwxr-xr-x 28 mysql mysql 4096 Mar 19 20:41 share drwxr-xr-x 2 mysql mysql 4096 Mar 19 20:41 docs drwxr-x--- 2 mysql mysql 4096 Mar 19 20:42 mysql-files -rw-r--r-- 1 mysql mysql 462 Mar 19 20:48 my.cnf drwxr-xr-x 2 mysql mysql 4096 Mar 19 20:56 log -rw------- 1 mysql mysql 5 Mar 19 20:56 mysql.sock.lock srwxrwxrwx 1 mysql mysql 0 Mar 19 20:56 mysql.sock drwxr-x--- 5 mysql mysql 4096 Mar 19 20:56 data [root@centos-mysql mysql]# ls -ld /usr/local/mysql lrwxrwxrwx 1 mysql mysql 35 Mar 19 20:42 /usr/local/mysql -> mysql-5.7.19-linux-glibc2.12-x86_64 ------ 麻烦各位大侠帮忙看看，为何在 my.cnf 配置文件的 [client] 和 [mysql] 域的配置参数不生效的问题，但测试修改 [mysqld] 服务器域的配置参数，重启数据库后是能生效的。 待复，感谢！
Samdy_Chan 2019-03-19 21:36 4598 2
前提条件： a表（a1，a2，a3字段），在a库的c表空间，索引a库的d表空间； b表（a1，a2，a3，a4（可以直接为空）字段），在b库的c表空间，索引在b库的d表空间； 需求如下： 从a库导出a表，然后导入到b库的b表。只导出表数据，不要索引。但是a表与b表相比，b表多了个字段。 请问可以怎么做导入？
Tingshao 2018-11-15 10:24 3471 0
CNDBA社区
