mysql 导出所有存储过程（mysql备份自动存储到开源的minio）

火客 2023-05-19 21:48:56 288

mysql 导出所有存储过程（mysql备份自动存储到开源的minio）１、192.168.1.1572.3.1 机器信息在mysql备份所在机器安装minio客户端[root@localhost ~]wget https://dl.min.io/client/mc/release/linux-amd64/mc [root@localhost ~]chmod x mc [root@localhost ~]# mv mc /usr/bin/mc [root@localhost ~]# mc --help NAME: mc - MinIO Client for cloud storage and filesystems. USAGE: mc [FLAGS] COMMAND [COMMAND FLAGS | -h] [ARGUMENTS...] COMMANDS: ls list buckets and objects mb make a bucke

概述

minio 是开源企业级对象存储系统，有着高性能、使用简单、易扩展、兼容性强等特性。下面分享一下如何把mysql备份自动存储在minio中。

mysql 导出所有存储过程（mysql备份自动存储到开源的minio）(1)

一、前提条件

安装minio客户端mc
已经安装好的minio server

二、使用过程

2.1 部署minio server

具体过程就不在这展示了，大家可以参考上一篇minio server部署文档

2.2 安装客户端

在mysql备份所在机器安装minio客户端

[root@localhost ~]wget https://dl.min.io/client/mc/release/linux-amd64/mc [root@localhost ~]chmod x mc [root@localhost ~]# mv mc /usr/bin/mc [root@localhost ~]# mc --help NAME: mc - MinIO Client for cloud storage and filesystems. USAGE: mc [FLAGS] COMMAND [COMMAND FLAGS | -h] [ARGUMENTS...] COMMANDS: ls list buckets and objects mb make a bucket rb remove a bucket cp copy objects mirror synchronize object(s) to a remote site cat display object contents head display first 'n' lines of an object pipe stream STDIN to an object share generate URL for temporary access to an object find search for objects sql run sql queries on objects stat show object metadata tree list buckets and objects in a tree format du summarize disk usage folder prefixes recursively diff list differences in object name size and date between two buckets rm remove objects event configure object notifications watch listen for object notification events policy manage anonymous access to buckets and objects admin manage MinIO servers session resume interrupted operations config configure MinIO client update update mc to latest release version show version info GLOBAL FLAGS: --autocompletion install auto-completion for your shell --config-dir value -C value path to configuration folder (default: "/root/.mc") --quiet -q disable progress bar display --no-color disable color theme --json enable JSON formatted output --debug enable debug output --insecure disable SSL certificate verification --help -h show help --version -v print the version TIP: Use 'mc --autocompletion' to enable shell autocompletion VERSION: RELEASE.2019-10-09T22-54-57Z

主要参数说明：