{"id":1436,"date":"2025-06-27T17:17:55","date_gmt":"2025-06-27T20:17:55","guid":{"rendered":"https:\/\/helpsysadmin.com.br\/blog\/?p=1436"},"modified":"2025-09-16T23:14:13","modified_gmt":"2025-09-17T02:14:13","slug":"backup-all-mysql-databases-on-a-linux-server","status":"publish","type":"post","link":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/","title":{"rendered":"Backup all MySQL databases on a Linux server"},"content":{"rendered":"<div id=\"helps-4085175272\" 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<h1 class=\"wp-block-heading\">Backup All MySQL Databases on Linux Server<\/h1>\n\n\n\n<h4 class=\"wp-block-heading\">What you will need:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access to the server&#8217;s <a href=\"https:\/\/helpsysadmin.com.br\/blog\/como-instalar-crowdsec\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Como instalar Crowdsec\" target=\"_blank\" rel=\"noopener\">Linux<\/a> shell with root (or sudo) user privileges.<\/li>\n\n\n\n<li>MySQL root user password.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Process description:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">This process backup all MySQL databases available on the server. For each database, an individual backup is generated in SQL format. Each file is then compressed (.gz), using the database name followed by the execution date as the file name (e.g., mydatabase_2025-06-27.gz). This facilitates organization, specific recovery, and versioning of backups.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Creating the shell file for backup<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create a file in the Linux shell:<\/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>Paste the following content into this file:<\/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\">save the file and exit nano (ctrl+x, y, enter)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Edit the file you created and change the line below with the mysql root password:<\/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\">save the file and exit nano (ctrl+x, y, enter)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Change the file permissions:<\/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\">By default, the backup will be created in \/backup\/mysql. If you wish, you can change the location to save the file by editing the created file and changing <strong>BACKUP_DIR<\/strong>=&#8221;\/backup\/mysql&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Running the backup:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run the file and wait for the process to complete:<\/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\">This is a simple but very useful script for backing up all MySQL databases on a Linux server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Backup All MySQL Databases on Linux Server What you will need: Process description: This process backup all MySQL databases available on the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1423,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1206,1209,1204],"tags":[1223,1211,1243,1245,1217],"class_list":["post-1436","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-security","category-server-management","tag-almalinux-en","tag-linux-en","tag-seguranca","tag-servidor-linux","tag-ubuntu-en-2"],"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 all MySQL databases on a Linux server - Blog HelpSysAdmin<\/title>\n<meta name=\"description\" content=\"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server\" \/>\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\/en\/backup-all-mysql-databases-on-a-linux-server\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup all MySQL databases on a Linux server\" \/>\n<meta property=\"og:description\" content=\"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog HelpSysAdmin\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-27T20:17:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-17T02:14:13+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\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/\"},\"author\":{\"name\":\"HelpSysAdmin\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\"},\"headline\":\"Backup all MySQL databases on a Linux server\",\"datePublished\":\"2025-06-27T20:17:55+00:00\",\"dateModified\":\"2025-09-17T02:14:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/\"},\"wordCount\":216,\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"keywords\":[\"almalinux\",\"linux\",\"seguran\u00e7a\",\"servidor linux\",\"ubuntu\"],\"articleSection\":[\"Linux\",\"Security\",\"server management\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/\",\"name\":\"Backup all MySQL databases on a Linux server - Blog HelpSysAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2025\\/06\\/mysql-backup.jpg\",\"datePublished\":\"2025-06-27T20:17:55+00:00\",\"dateModified\":\"2025-09-17T02:14:13+00:00\",\"description\":\"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#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\\\/en\\\/backup-all-mysql-databases-on-a-linux-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup all MySQL databases on a Linux server\"}]},{\"@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 all MySQL databases on a Linux server - Blog HelpSysAdmin","description":"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server","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\/en\/backup-all-mysql-databases-on-a-linux-server\/","og_locale":"pt_BR","og_type":"article","og_title":"Backup all MySQL databases on a Linux server","og_description":"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server","og_url":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/","og_site_name":"Blog HelpSysAdmin","article_published_time":"2025-06-27T20:17:55+00:00","article_modified_time":"2025-09-17T02:14:13+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\/en\/backup-all-mysql-databases-on-a-linux-server\/#article","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/"},"author":{"name":"HelpSysAdmin","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb"},"headline":"Backup all MySQL databases on a Linux server","datePublished":"2025-06-27T20:17:55+00:00","dateModified":"2025-09-17T02:14:13+00:00","mainEntityOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/"},"wordCount":216,"publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/#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","ubuntu"],"articleSection":["Linux","Security","server management"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/","url":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/","name":"Backup all MySQL databases on a Linux server - Blog HelpSysAdmin","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/#primaryimage"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/#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-27T20:17:55+00:00","dateModified":"2025-09-17T02:14:13+00:00","description":"Blog HelpSysAdmin - Backup all MySQL databases on a Linux server","breadcrumb":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/backup-all-mysql-databases-on-a-linux-server\/#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\/en\/backup-all-mysql-databases-on-a-linux-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpsysadmin.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Backup all MySQL databases on a Linux server"}]},{"@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":"en","translations":{"en":1436},"pll_sync_post":{},"_links":{"self":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1436","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=1436"}],"version-history":[{"count":5,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1436\/revisions"}],"predecessor-version":[{"id":1512,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/1436\/revisions\/1512"}],"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=1436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}