一、MySQL日志管理MySQL 的日志默认保存位置为/usr/local/mysql/data MySQL 的日志配置文件为 /etc/my.cnf，里面有个[mysqld]项。1.1 日志的分类1.1.1错误日志用来记录当MySQL启动、停止或运行时发生的错误信息，默认已开启vim /etc/m...

大数据运维之MySQL备份及恢复

一、MySQL备份概述1、为什么要备份能够防止由于机械故障以及人为误操作带来的数据丢失，例如将数据库文件保存在了其它地方。冗余：数据有多份冗余，但不等备份，只能防止机械故障还来的数据丢失，例如主备模式、数据库集群。2、备份必须重视的内容备份内容 databases Bin...

Mysql数据库的备份与恢复

一、Mysql数据库备份的相关概述备份的目的：用于灾难恢复、测试应用、回滚数据修改、查询历史数据、审计等数据丢失的原因：（1）程序错误（2）人为操作失误（3）运算错误（4）磁盘故障（5）灾难和盗窃等二、数据库备份的类型- 从物理和...

MySQL数据库的备份与恢复（下）

示例1：只想恢复"小号"和"长号"（即恢复最后两行，第7~8行）use yuji; delete from class where cid between 5 and 8; #删除cid为5到8的数据记录 cat /bak/binlog.txt #查看二进制文件内容，找到小号的位置...

共有252条

< 1 2 3 4 ... 26 >

跳转至： GO

更新时间 2023-01-10 23:35:28

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

产品推荐

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","link":"https://www.aliyun.com/product/apsaradb/polardbm","icon":"polardb","iconImg":"https://img.alicdn.com/imgextra/i2/O1CN01Gd7JcA1Lu0gS1c4Sm_!!6000000001358-2-tps-48-48.png","contentLink":"https://www.aliyun.com/product/apsaradb/polardbm","title":"云原生数据库 PolarDB MySQL 版","des":"云原生数据库 PolarDB MySQL 版是阿里云自研产品，100%兼容 MySQL。产品具有多主多写、多活容灾、HTAP特性，交易性能最高可达开源数据库的6倍，分析性能最高可达开源数据库的400倍，TCO 低于自建数据库50%。","link1":"https://www.aliyun.com/product/apsaradb/polardbm","btn1":"了解详情","link2":"https://polardb.console.aliyun.com/cn-hangzhou/clusters?spm=5176.28041492.J_5253785160.3.3ffa57d5tWeqn5","btn2":"管理控制台","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?spm=5176.8789780.7y9jhqsfz.115.47ea55caeL2Mfu&from=OVtXEBmlH8","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"PolarDB MySQL试用","firstContentLink":"https://free.aliyun.com/?searchKey=PolarDB%20MySQL","lastContentName":"","lastContentLink":""}},{"infoName":"快速入门","infoContent":{"firstContentName":"产品介绍","firstContentLink":"https://help.aliyun.com/document_detail/58764.html","lastContentName":"快速入门","lastContentLink":"https://help.aliyun.com/document_detail/139453.html"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"大版本升级最佳实践","firstContentLink":"https://help.aliyun.com/document_detail/606316.html","lastContentName":"内核最佳实践","lastContentLink":"https://help.aliyun.com/document_detail/443297.html"}},{"infoName":"产品推荐","infoContent":{"firstContentName":"PolarDB分布式版","lastContentName":"PolarDB PostgreSQL版","firstContentLink":"https://www.aliyun.com/product/apsaradb/polardbx","lastContentLink":"https://www.aliyun.com/product/apsaradb/polardbpg"}}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"","subtitle":"","linkUrl":"","btnText":""},"visual":{"topbg":"","icon":"","textColor":"dark"},"dataList":[],"sceneCard":[],"txt":[],"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}}}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","link":"https://www.aliyun.com/product/apsaradb/polardbm","icon":"polardb","iconImg":"https://img.alicdn.com/imgextra/i2/O1CN01Gd7JcA1Lu0gS1c4Sm_!!6000000001358-2-tps-48-48.png","contentLink":"https://www.aliyun.com/product/apsaradb/polardbm","title":"云原生数据库 PolarDB MySQL 版","des":"云原生数据库 PolarDB MySQL 版是阿里云自研产品，100%兼容 MySQL。产品具有多主多写、多活容灾、HTAP特性，交易性能最高可达开源数据库的6倍，分析性能最高可达开源数据库的400倍，TCO 低于自建数据库50%。","link1":"https://www.aliyun.com/product/apsaradb/polardbm","btn1":"了解详情","link2":"https://polardb.console.aliyun.com/cn-hangzhou/clusters?spm=5176.28041492.J_5253785160.3.3ffa57d5tWeqn5","btn2":"管理控制台","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?spm=5176.8789780.7y9jhqsfz.115.47ea55caeL2Mfu&from=OVtXEBmlH8","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"PolarDB MySQL试用","firstContentLink":"https://free.aliyun.com/?searchKey=PolarDB%20MySQL","lastContentName":"","lastContentLink":""}},{"infoName":"快速入门","infoContent":{"firstContentName":"产品介绍","firstContentLink":"https://help.aliyun.com/document_detail/58764.html","lastContentName":"快速入门","lastContentLink":"https://help.aliyun.com/document_detail/139453.html"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"大版本升级最佳实践","firstContentLink":"https://help.aliyun.com/document_detail/606316.html","lastContentName":"内核最佳实践","lastContentLink":"https://help.aliyun.com/document_detail/443297.html"}},{"infoName":"产品推荐","infoContent":{"firstContentName":"PolarDB分布式版","lastContentName":"PolarDB PostgreSQL版","firstContentLink":"https://www.aliyun.com/product/apsaradb/polardbx","lastContentLink":"https://www.aliyun.com/product/apsaradb/polardbpg"}}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"","subtitle":"","linkUrl":"","btnText":""},"visual":{"topbg":"","icon":"","textColor":"dark"},"dataList":[],"sceneCard":[],"txt":[],"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}}}}

云原生数据库 PolarDB MySQL 版

云原生数据库 PolarDB MySQL 版是阿里云自研产品，100%兼容 MySQL。产品具有多主多写、多活容灾、HTAP特性，交易性能最高可达开源数据库的6倍，分析性能最高可达开源数据库的400倍，TCO 低于自建数据库50%。

了解详情

管理控制台

在线咨询