{"id":1422,"date":"2025-06-27T15:08:47","date_gmt":"2025-06-27T18:08:47","guid":{"rendered":"https:\/\/helpsysadmin.com.br\/blog\/?p=1422"},"modified":"2026-01-03T23:13:55","modified_gmt":"2026-01-04T02:13:55","slug":"backup-de-todos-os-bancos-de-dados-mysql","status":"publish","type":"post","link":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/","title":{"rendered":"Backup de todos os bancos de dados mysql em um servidor Linux"},"content":{"rendered":"<div id=\"helps-2583023624\" class=\"helps-before-content-2 helps-entity-placement\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-3661896953164277\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- 2anuncios display quadrado -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-3661896953164277\"\r\n     data-ad-slot=\"5051229894\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\n<h4 class=\"wp-block-heading\" id=\"h-o-que-sera-necessario\">O que ser\u00e1 necess\u00e1rio:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Acesso ao shell <a href=\"https:\/\/helpsysadmin.com.br\/blog\/como-instalar-crowdsec\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Como instalar Crowdsec\" target=\"_blank\" rel=\"noopener\">Linux<\/a> do servidor com usu\u00e1rio root(ou sudo)<\/li>\n\n\n\n<li>Senha do usu\u00e1rio root do mysql<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-descricao-do-processo\">Descri\u00e7\u00e3o do processo:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Este processo realiza o backup de todos os bancos de dados mysql dispon\u00edveis no servidor. Para cada banco de dados, \u00e9 gerado um backup individual em formato SQL. Em seguida, cada arquivo \u00e9 compactado (<code>.gz<\/code>), utilizando como nome o pr\u00f3prio banco de dados seguido da data de execu\u00e7\u00e3o (por exemplo: <code>meubanco_2025-06-27.gz<\/code>). Isso facilita a organiza\u00e7\u00e3o, a recupera\u00e7\u00e3o espec\u00edfica e o versionamento dos backups.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-criando-o-arquivo-shell-para-backup\">Criando o arquivo shell para backup<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Crie um arquivo no shell do linux:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>nano backup_mysql.sh<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Neste arquivo cole o conte\u00fado abaixo:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>#!\/bin\/bash\n\n# Script de backup MySQL para usu\u00e1rio root\n# Configura\u00e7\u00f5es do MySQL\nMYSQL_USER=&quot;root&quot;\nMYSQL_PASSWORD=&quot;sua_senha_root_segura_do_mysql&quot;\nMYSQL_HOST=&quot;localhost&quot;\nMYSQL_PORT=&quot;3306&quot;\n\n# Diret\u00f3rio onde os backups ser\u00e3o salvos\nBACKUP_DIR=&quot;\/backup\/mysql&quot;\nDATE=$(date +&quot;%Y%m%d_%H%M%S&quot;)\n\n# Verificar se est\u00e1 sendo executado como root\nif [ &quot;$EUID&quot; -ne 0 ]; then\n    echo &quot;Este script deve ser executado como root (sudo).&quot;\n    echo &quot;Use: sudo .\/backup_mysql.sh&quot;\n    exit 1\nfi\n\n# Criar diret\u00f3rio de backup se n\u00e3o existir\nmkdir -p &quot;$BACKUP_DIR&quot;\n\n# Cores para output\nRED='\\033[0;31m'\nGREEN='\\033[0;32m'\nYELLOW='\\033[1;33m'\nBLUE='\\033[0;34m'\nNC='\\033[0m' # No Color\n\necho -e &quot;${BLUE}=== Backup MySQL - Usu\u00e1rio Root ===${NC}&quot;\necho &quot;Data\/Hora: $(date)&quot;\necho &quot;Usu\u00e1rio: root&quot;\necho &quot;Host: $MYSQL_HOST&quot;\necho &quot;Diret\u00f3rio de backup: $BACKUP_DIR&quot;\necho &quot;&quot;\n\n# Tentar v\u00e1rias formas de autentica\u00e7\u00e3o para root\necho &quot;Tentando conectar como root...&quot;\n\n# M\u00e9todo 1: Sem senha (auth_socket)\nmysql -u root -e &quot;SELECT 1;&quot; &amp;&gt;\/dev\/null\nif [ $? -eq 0 ]; then\n    echo -e &quot;${GREEN}\u2713 Conectado usando auth_socket (sem senha)${NC}&quot;\n    AUTH_METHOD=&quot;no_password&quot;\nelse\n    # M\u00e9todo 2: Com senha\n    if [ -z &quot;$MYSQL_PASSWORD&quot; ]; then\n        echo -n &quot;Digite a senha do MySQL root: &quot;\n        read -s MYSQL_PASSWORD\n        echo &quot;&quot;\n    fi\n    \n    mysql -u root -p&quot;$MYSQL_PASSWORD&quot; -e &quot;SELECT 1;&quot; &amp;&gt;\/dev\/null\n    if [ $? -eq 0 ]; then\n        echo -e &quot;${GREEN}\u2713 Conectado usando senha${NC}&quot;\n        AUTH_METHOD=&quot;with_password&quot;\n    else\n        echo -e &quot;${RED}Erro: N\u00e3o foi poss\u00edvel conectar ao MySQL como root.${NC}&quot;\n        echo &quot;Verifique se:&quot;\n        echo &quot;1. O MySQL est\u00e1 rodando&quot;\n        echo &quot;2. A senha est\u00e1 correta&quot;\n        echo &quot;3. O usu\u00e1rio root tem permiss\u00f5es adequadas&quot;\n        exit 1\n    fi\nfi\n\necho &quot;&quot;\n\n# Fun\u00e7\u00e3o para executar comandos MySQL baseado no m\u00e9todo de autentica\u00e7\u00e3o\nexecute_mysql() {\n    if [ &quot;$AUTH_METHOD&quot; = &quot;no_password&quot; ]; then\n        mysql -u root &quot;$@&quot;\n    else\n        mysql -u root -p&quot;$MYSQL_PASSWORD&quot; &quot;$@&quot;\n    fi\n}\n\n# Fun\u00e7\u00e3o para executar mysqldump baseado no m\u00e9todo de autentica\u00e7\u00e3o\nexecute_mysqldump() {\n    if [ &quot;$AUTH_METHOD&quot; = &quot;no_password&quot; ]; then\n        mysqldump -u root &quot;$@&quot;\n    else\n        mysqldump -u root -p&quot;$MYSQL_PASSWORD&quot; &quot;$@&quot;\n    fi\n}\n\n# Obter lista de todos os bancos de dados (excluindo system databases)\necho &quot;Buscando bancos de dados...&quot;\nDATABASES=$(execute_mysql -e &quot;SHOW DATABASES;&quot; | grep -v -E &quot;^(Database|information_schema|performance_schema|mysql|sys)$&quot;)\n\nif [ -z &quot;$DATABASES&quot; ]; then\n    echo -e &quot;${YELLOW}Nenhum banco de dados de usu\u00e1rio encontrado para backup.${NC}&quot;\n    exit 0\nfi\n\necho -e &quot;${GREEN}Bancos de dados encontrados:${NC}&quot;\nfor db in $DATABASES; do\n    echo &quot;  - $db&quot;\ndone\necho &quot;&quot;\n\n# Contador para estat\u00edsticas\nTOTAL_DATABASES=$(echo &quot;$DATABASES&quot; | wc -l)\nSUCCESS_COUNT=0\nERROR_COUNT=0\n\n# Fazer backup de cada banco de dados\nfor DATABASE in $DATABASES; do\n    echo -e &quot;${YELLOW}Fazendo backup do banco: $DATABASE${NC}&quot;\n    \n    # Nome do arquivo de backup\n    BACKUP_FILE=&quot;$BACKUP_DIR\/${DATABASE}_${DATE}.sql&quot;\n    \n    # Executar mysqldump com op\u00e7\u00f5es otimizadas para root\n    execute_mysqldump \\\n        --single-transaction \\\n        --routines \\\n        --triggers \\\n        --events \\\n        --hex-blob \\\n        --add-drop-database \\\n        --complete-insert \\\n        --disable-keys \\\n        --extended-insert \\\n        --quick \\\n        --lock-tables=false \\\n        --databases &quot;$DATABASE&quot; &gt; &quot;$BACKUP_FILE&quot; 2&gt;\/dev\/null\n    \n    # Verificar se o backup foi bem-sucedido\n    if [ $? -eq 0 ] &amp;&amp; [ -s &quot;$BACKUP_FILE&quot; ]; then\n        FILE_SIZE=$(du -h &quot;$BACKUP_FILE&quot; | cut -f1)\n        echo -e &quot;${GREEN}  \u2713 Dump criado: $FILE_SIZE${NC}&quot;\n        \n        # Comprimir o arquivo\n        echo &quot;  Comprimindo arquivo...&quot;\n        gzip &quot;$BACKUP_FILE&quot;\n        \n        if [ $? -eq 0 ]; then\n            COMPRESSED_SIZE=$(du -h &quot;${BACKUP_FILE}.gz&quot; | cut -f1)\n            echo -e &quot;${GREEN}  \u2713 Comprimido: $COMPRESSED_SIZE${NC}&quot;\n            ((SUCCESS_COUNT++))\n        else\n            echo -e &quot;${RED}  \u2717 Erro na compress\u00e3o${NC}&quot;\n            ((ERROR_COUNT++))\n        fi\n    else\n        echo -e &quot;${RED}  \u2717 Erro no backup do banco: $DATABASE${NC}&quot;\n        ((ERROR_COUNT++))\n        # Remover arquivo vazio ou corrompido\n        [ -f &quot;$BACKUP_FILE&quot; ] &amp;&amp; rm &quot;$BACKUP_FILE&quot;\n    fi\n    echo &quot;&quot;\ndone\n\n# Definir permiss\u00f5es adequadas para os arquivos de backup\necho &quot;Definindo permiss\u00f5es dos arquivos...&quot;\nchown root:root &quot;$BACKUP_DIR&quot;\/*.gz 2&gt;\/dev\/null\nchmod 600 &quot;$BACKUP_DIR&quot;\/*.gz 2&gt;\/dev\/null\n\n# Relat\u00f3rio final\necho -e &quot;${BLUE}=== Relat\u00f3rio Final ===${NC}&quot;\necho &quot;Total de bancos processados: $TOTAL_DATABASES&quot;\necho -e &quot;${GREEN}Backups bem-sucedidos: $SUCCESS_COUNT${NC}&quot;\nif [ $ERROR_COUNT -gt 0 ]; then\n    echo -e &quot;${RED}Erros encontrados: $ERROR_COUNT${NC}&quot;\nfi\necho &quot;&quot;\n\n# Mostrar espa\u00e7o em disco usado\nTOTAL_SIZE=$(du -sh &quot;$BACKUP_DIR&quot; 2&gt;\/dev\/null | cut -f1)\necho &quot;Espa\u00e7o total usado: $TOTAL_SIZE&quot;\necho &quot;Arquivos salvos em: $BACKUP_DIR&quot;\necho &quot;&quot;\n\n# Listar arquivos criados\necho -e &quot;${GREEN}Arquivos de backup criados hoje:${NC}&quot;\nls -lah &quot;$BACKUP_DIR&quot;\/*_${DATE}.sql.gz 2&gt;\/dev\/null | while read line; do\n    echo &quot;  $line&quot;\ndone\n\n# Limpeza de backups antigos (manter apenas os \u00faltimos 7 dias)\necho &quot;&quot;\necho -e &quot;${YELLOW}Limpando backups antigos (mais de 7 dias)...${NC}&quot;\nDELETED_FILES=$(find &quot;$BACKUP_DIR&quot; -name &quot;*.sql.gz&quot; -mtime +7 -print)\nif [ -n &quot;$DELETED_FILES&quot; ]; then\n    echo &quot;Arquivos removidos:&quot;\n    echo &quot;$DELETED_FILES&quot; | while read file; do\n        echo &quot;  - $(basename &quot;$file&quot;)&quot;\n    done\n    find &quot;$BACKUP_DIR&quot; -name &quot;*.sql.gz&quot; -mtime +7 -delete\nelse\n    echo &quot;Nenhum arquivo antigo encontrado para remo\u00e7\u00e3o.&quot;\nfi\n\n# Verificar espa\u00e7o em disco\necho &quot;&quot;\necho -e &quot;${BLUE}Status do sistema:${NC}&quot;\necho &quot;Espa\u00e7o livre em disco:&quot;\ndf -h &quot;$BACKUP_DIR&quot; | tail -1 | awk '{print &quot;  Usado: &quot; $3 &quot; | Dispon\u00edvel: &quot; $4 &quot; | Uso: &quot; $5}'\n\necho &quot;&quot;\necho -e &quot;${GREEN}Backup finalizado com sucesso!${NC}&quot;\necho &quot;Finalizado em: $(date)&quot;\n\n# Log do backup\nLOG_FILE=&quot;$BACKUP_DIR\/backup_$(date +%Y%m).log&quot;\necho &quot;$(date): Backup realizado - $SUCCESS_COUNT sucessos, $ERROR_COUNT erros&quot; &gt;&gt; &quot;$LOG_FILE&quot;\n<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Salve o arquivo e saida do nano (ctrl+x, y, enter)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Edite o arquivo que criou e altere a linha abaixo com a senha do root do mysql:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>MYSQL_PASSWORD=&quot;sua_senha_root_segura_do_mysql&quot;<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Salve o arquivo e saia do nano (ctrl+x, y, enter)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Altere as permiss\u00f5es do arquivo:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>chmod +x backup_mysql.sh<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Como padr\u00e3o o backup ser\u00e1 criado em \/backup\/mysql . Se desejar voc\u00ea pode alterar o local para salvar o arquivo editando o arquivo criado e alterando BACKUP_DIR=&#8221;\/backup\/mysql&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Executando o backup:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Execute o arquivo e aguarde o processo:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>.\/backup_mysql.sh<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Esse \u00e9 um script simples mas muito \u00fatil para Backup de Todos os Bancos de Dados mysql no Servidor Linux.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/restaurar-banco-de-dados-mysql-workbench\/\">Restaurando MySQL usando o MySQL Workbench<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/erros-que-todo-sysadmin-iniciante-comete\/\">Erros que todo sysadmin iniciante comete<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/dispositivos-de-armazenamento-secundario\/\">Dispositivos de Armazenamento Secund\u00e1rio: Defini\u00e7\u00e3o, Tipos e Casos de Uso em Backup<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/gerenciar-servidores-em-producao\/\">O que ningu\u00e9m te conta sobre gerenciar servidores em produ\u00e7\u00e3o<\/a><\/strong><br><br>See More: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/en\/install-portainer-for-docker-with-nginx-proxy-manager\/\">How to Install Portainer for Docker Management with Nginx Proxy Manager on Ubuntu<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>O que ser\u00e1 necess\u00e1rio: Descri\u00e7\u00e3o do processo: Este processo realiza o backup de todos os bancos de dados mysql dispon\u00edveis no servidor. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1423,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1279,89],"tags":[90,13,18,3],"class_list":["post-1422","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gerenciamento-servidor","category-linux","category-seguranca-do-servidor","tag-almalinux","tag-linux","tag-seguranca","tag-servidor-linux"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v27.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Backup de todos os bancos de dados mysql em um servidor Linux - Blog HelpSysAdmin<\/title>\n<meta name=\"description\" content=\"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup de todos os bancos de dados mysql em um servidor Linux\" \/>\n<meta property=\"og:description\" content=\"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog HelpSysAdmin\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-27T18:08:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-04T02:13:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"825\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"HelpSysAdmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brhelpsysad\" \/>\n<meta name=\"twitter:site\" content=\"@brhelpsysad\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/\"},\"author\":{\"name\":\"HelpSysAdmin\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\"},\"headline\":\"Backup de todos os bancos de dados mysql em um servidor Linux\",\"datePublished\":\"2025-06-27T18:08:47+00:00\",\"dateModified\":\"2026-01-04T02:13:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/\"},\"wordCount\":291,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"keywords\":[\"almalinux\",\"linux\",\"seguran\u00e7a\",\"servidor linux\"],\"articleSection\":[\"Gerenciamento de Servidor\",\"Linux\",\"Seguran\u00e7a\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/\",\"name\":\"Backup de todos os bancos de dados mysql em um servidor Linux - Blog HelpSysAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"datePublished\":\"2025-06-27T18:08:47+00:00\",\"dateModified\":\"2026-01-04T02:13:55+00:00\",\"description\":\"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#primaryimage\",\"url\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"contentUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"width\":825,\"height\":500,\"caption\":\"Backup de todos os bancos de dados mysql em servidor linux\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/backup-de-todos-os-bancos-de-dados-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup de todos os bancos de dados mysql em um servidor Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"name\":\"Blog HelpSysAdmin\",\"description\":\"Webserver linux blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"alternateName\":\"HelpSysAdmin Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\",\"name\":\"HelpSysAdmin Gerenciamento de Servidores\",\"alternateName\":\"HelpSysAdmin\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"contentUrl\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"HelpSysAdmin Gerenciamento de Servidores\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/brhelpsysad\",\"https:\\\/\\\/mastodon.social\\\/@helpsysadmin\"],\"description\":\"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1\",\"maxValue\":\"10\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\",\"name\":\"HelpSysAdmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g\",\"caption\":\"HelpSysAdmin\"},\"sameAs\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Backup de todos os bancos de dados mysql em um servidor Linux - Blog HelpSysAdmin","description":"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/","og_locale":"pt_BR","og_type":"article","og_title":"Backup de todos os bancos de dados mysql em um servidor Linux","og_description":"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.","og_url":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/","og_site_name":"Blog HelpSysAdmin","article_published_time":"2025-06-27T18:08:47+00:00","article_modified_time":"2026-01-04T02:13:55+00:00","og_image":[{"width":825,"height":500,"url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg","type":"image\/jpeg"}],"author":"HelpSysAdmin","twitter_card":"summary_large_image","twitter_creator":"@brhelpsysad","twitter_site":"@brhelpsysad","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#article","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/"},"author":{"name":"HelpSysAdmin","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb"},"headline":"Backup de todos os bancos de dados mysql em um servidor Linux","datePublished":"2025-06-27T18:08:47+00:00","dateModified":"2026-01-04T02:13:55+00:00","mainEntityOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/"},"wordCount":291,"commentCount":0,"publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg","keywords":["almalinux","linux","seguran\u00e7a","servidor linux"],"articleSection":["Gerenciamento de Servidor","Linux","Seguran\u00e7a"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/","url":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/","name":"Backup de todos os bancos de dados mysql em um servidor Linux - Blog HelpSysAdmin","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#primaryimage"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg","datePublished":"2025-06-27T18:08:47+00:00","dateModified":"2026-01-04T02:13:55+00:00","description":"Guia completo para realizar o backup de todos os bancos de dados MySQL em um servidor Linux.","breadcrumb":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#primaryimage","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2025\/06\/mysql-backup.jpg","width":825,"height":500,"caption":"Backup de todos os bancos de dados mysql em servidor linux"},{"@type":"BreadcrumbList","@id":"https:\/\/helpsysadmin.com.br\/blog\/backup-de-todos-os-bancos-de-dados-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpsysadmin.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Backup de todos os bancos de dados mysql em um servidor Linux"}]},{"@type":"WebSite","@id":"https:\/\/helpsysadmin.com.br\/blog\/#website","url":"https:\/\/helpsysadmin.com.br\/blog\/","name":"Blog HelpSysAdmin","description":"Webserver linux blog","publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"alternateName":"HelpSysAdmin Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/helpsysadmin.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization","name":"HelpSysAdmin Gerenciamento de Servidores","alternateName":"HelpSysAdmin","url":"https:\/\/helpsysadmin.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","width":512,"height":512,"caption":"HelpSysAdmin Gerenciamento de Servidores"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/brhelpsysad","https:\/\/mastodon.social\/@helpsysadmin"],"description":"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1","maxValue":"10"}},{"@type":"Person","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb","name":"HelpSysAdmin","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efc0007e6a313a844b72de257e05c6083b07b6ecc6983a4f71e06293ff2e22fd?s=96&d=mm&r=g","caption":"HelpSysAdmin"},"sameAs":["https:\/\/helpsysadmin.com.br\/blog\/"]}]}},"lang":"pt","translations":{"pt":1422},"pll_sync_post":{},"_links":{"self":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1422"}],"version-history":[{"count":5,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1422\/revisions"}],"predecessor-version":[{"id":2458,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1422\/revisions\/2458"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media\/1423"}],"wp:attachment":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}