{"id":23992,"date":"2019-02-25T02:35:19","date_gmt":"2019-02-25T10:35:19","guid":{"rendered":"https:\/\/kinsta.com\/?post_type=knowledgebase&#038;p=8987"},"modified":"2025-10-01T17:11:08","modified_gmt":"2025-10-01T20:11:08","slug":"mysql-backup-database","status":"publish","type":"post","link":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/","title":{"rendered":"Como Fazer o Backup da Base de Dados MySQL (2 M\u00e9todos Incrivelmente F\u00e1ceis)"},"content":{"rendered":"<p>Precisa de um backup de banco de dados MySQL? A maioria dos hosts WordPress, incluindo Kinsta, fazem <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/backups-wordpress\/\" target=\"_blank\" rel=\"noopener noreferrer\">backups automatizados<\/a>, por isso n\u00e3o precisa de se preocupar em ficar fazendo manualmente um backup em caso de emerg\u00eancia.<\/p>\n<p>Entretanto, pode haver momentos em que voc\u00ea precise de uma c\u00f3pia do seu \u00faltimo banco de dados MySQL. Isto pode ser porque voc\u00ea est\u00e1 migrando hosts ou talvez voc\u00ea queira fazer algum desenvolvimento local. Em qualquer caso, voc\u00ea pode seguir este tutorial r\u00e1pido e f\u00e1cil abaixo sobre como fazer backup de seu banco de dados <a href=\"https:\/\/kinsta.com\/pt\/blog\/o-que-e-mysql\/\">MySQL<\/a> de duas maneiras incrivelmente f\u00e1ceis.<\/p>\n<ul>\n<li><a href=\"#phpmyadmin\">Como Fazer o Backup da Base de Dados MySQL Com phpMyAdmin<\/a><\/li>\n<li><a href=\"#mykinsta\">Como fazer backup do banco de dados MySQL em MyKinsta<\/a><\/li>\n<\/ul>\n<h2 id=\"phpmyadmin\">Como Fazer o Backup da Base de Dados MySQL Com phpMyAdmin<\/h2>\n<p>O phpMyAdmin \u00e9 uma ferramenta gratuita open-source dispon\u00edvel no seu navegador, utilizada para gerenciar a administra\u00e7\u00e3o do MySQL ou MariaDB.\u00a0Ele pode ser usado para todos os tipos de opera\u00e7\u00f5es diferentes, como migrar bases de dados, gerenciar tabelas, \u00edndices e executar instru\u00e7\u00f5es SQL.\u00a0Hoje iremos simplesmente exportar um banco de dados mySQL do WordPress com o phpMyAdmin.<\/p>\n<h3>Passo 1<\/h3>\n<p>Fa\u00e7a login no phpMyAdmin. Se voc\u00ea \u00e9 cliente Kinsta, h\u00e1 um link de f\u00e1cil acesso (junto com as credenciais) para <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/gerenciamento-de-banco-de-dados\/acesso-ao-banco-de-dados-wordpress\/\">abrir o phpMyAdmin<\/a> no painel MyKinsta.<\/p>\n<figure id=\"attachment_196789\" aria-describedby=\"caption-attachment-196789\" style=\"width: 2296px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-196789 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-open-phpmyadmin-1.png\" alt=\"Acessando o phpMyAdmin no painel MyKinsta.\" width=\"2296\" height=\"530\"><figcaption id=\"caption-attachment-196789\" class=\"wp-caption-text\">Acessando o phpMyAdmin no painel MyKinsta.<\/figcaption><\/figure>\n<p>Se voc\u00ea estiver usando <a href=\"https:\/\/kinsta.com\/pt\/blog\/o-que-e-cpanel\/\">cPainel<\/a>, um link para o phpMyAdmin estar\u00e1 localizado na se\u00e7\u00e3o &#8220;Bancos de dados&#8221;.<\/p>\n<figure id=\"attachment_49958\" aria-describedby=\"caption-attachment-49958\" style=\"width: 1982px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49958 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/phpmyadmin-cpanel.png\" alt=\"cPanel phpMyAdmin\" width=\"1982\" height=\"422\"><figcaption id=\"caption-attachment-49958\" class=\"wp-caption-text\">cPanel phpMyAdmin<\/figcaption><\/figure>\n<h3>Passo 2<\/h3>\n<p>Clique na sua base de dados WordPress.\u00a0O mais prov\u00e1vel \u00e9 que o nome corresponda ao nome do seu site\u00a0ou nome de usu\u00e1rio.<\/p>\n<figure id=\"attachment_49959\" aria-describedby=\"caption-attachment-49959\" style=\"width: 1358px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49959 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/base-de-dados-phpmyadmin-no-wordpress.png\" alt=\"base de dados phpMyAdmin no WordPress\" width=\"1358\" height=\"578\"><figcaption id=\"caption-attachment-49959\" class=\"wp-caption-text\">base de dados phpMyAdmin no WordPress<\/figcaption><\/figure>\n<h3>Passo 3<\/h3>\n<p>Existem duas op\u00e7\u00f5es que voc\u00ea tem na pr\u00f3xima etapa. Depende de como voc\u00ea deseja usar o banco de dados.<\/p>\n<h4>Op\u00e7\u00e3o 1 \u2013 M\u00e9todo de Exporta\u00e7\u00e3o R\u00e1pida<\/h4>\n<p>Clique no separador \u201cExportar\u201d. Se voc\u00ea vai usar sua base de dados em um lugar onde n\u00e3o existe uma vers\u00e3o antiga, ou se quer apenas um backup, voc\u00ea pode selecionar a op\u00e7\u00e3o \u201cR\u00e1pido \u2013 exibir apenas as op\u00e7\u00f5es m\u00ednimas\u201d. Depois clique em \u201cIr.\u201d<\/p>\n<figure id=\"attachment_49960\" aria-describedby=\"caption-attachment-49960\" style=\"width: 1409px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49960 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/exportar-tabelas-no-phpmyadmin.jpg\" alt=\"Exportar tabelas no phpmyadmin\" width=\"1409\" height=\"754\"><figcaption id=\"caption-attachment-49960\" class=\"wp-caption-text\">Exportar tabelas no phpmyadmin<\/figcaption><\/figure>\n<p>Isso ir\u00e1 gerar um arquivo <code>.sql<\/code> que voc\u00ea pode manter como backup ou restaurar\/importar em outro lugar. Note que a base de dados WordPress cont\u00e9m apenas as informa\u00e7\u00f5es do seu site, os arquivos (plugins\/temas) s\u00e3o totalmente separados e devem ser baixados e copiados por SFTP.<\/p>\n<h4>Op\u00e7\u00e3o 2\u00a0\u2013 M\u00e9todo de Exporta\u00e7\u00e3o Personalizado<\/h4>\n<p>Se voc\u00ea vai importar sua base de dados para um lugar onde ela j\u00e1 existe com tabelas de mesmo nome, deve escolher a op\u00e7\u00e3o \u201cPersonalizado \u2013 exibir todas as op\u00e7\u00f5es poss\u00edveis\u201d.<\/p>\n<figure id=\"attachment_49961\" aria-describedby=\"caption-attachment-49961\" style=\"width: 1475px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49961 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/exportacao-personalizada-do-phpmyadmin.png\" alt=\"exporta\u00e7\u00e3o personalizada do phpmyadmin\" width=\"1475\" height=\"498\"><figcaption id=\"caption-attachment-49961\" class=\"wp-caption-text\">exporta\u00e7\u00e3o personalizada do phpmyadmin<\/figcaption><\/figure>\n<p>Navegue para baixo at\u00e9 a se\u00e7\u00e3o de op\u00e7\u00f5es de cria\u00e7\u00e3o de objetos e selecione \u201cAdicionar afirma\u00e7\u00e3o DROP TABLE \/ VIEW \/ PROCEDURE \/ FUNCTION \/ EVENT \/ TRIGGER\u201d. Isso ir\u00e1 garantir que ele simplesmente sobrescreve as tabelas existentes com o mesmo nome.<\/p>\n<figure id=\"attachment_49962\" aria-describedby=\"caption-attachment-49962\" style=\"width: 1296px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49962 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/adicionar-drop-table-no-phpmyadmin.png\" alt=\"Adicionar drop table no phpmyadmin\" width=\"1296\" height=\"964\"><figcaption id=\"caption-attachment-49962\" class=\"wp-caption-text\">Adicionar drop table no phpmyadmin<\/figcaption><\/figure>\n<p>Depois, clique em \u201cIr\u201d. Isso ir\u00e1 gerar um arquivo <code>.sql<\/code> que voc\u00ea pode manter como backup ou restaurar\/importar em outro lugar.<\/p>\n<h2>Como fazer o backup do banco de dados MySQL no MyKinsta<\/h2>\n<p>Se voc\u00ea \u00e9 um cliente Kinsta, h\u00e1 duas op\u00e7\u00f5es para fazer backup do seu banco de dados MySQL &#8211; <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/backups-wordpress\/#wordpress-backup#downloadable-backups\">backups para download<\/a> e <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/backups-wordpress\/#external-backups-addon\">backups externos<\/a>.<\/p>\n<h3>Fa\u00e7a backup de seu banco de dados MySQL com backups que podem ser baixados<\/h3>\n<p>Estes s\u00e3o um arquivo de arquivo (<code>.zip<\/code>) contendo todo o seu site WordPress. O arquivo cont\u00e9m os arquivos do seu website, bem como o <b>arquivo SQL<\/b> que cont\u00e9m o conte\u00fado do banco de dados.<\/p>\n<p>Voc\u00ea pode encontrar isso na guia <strong>Backups<\/strong> em seus sites individuais. Juntamente com os backups di\u00e1rios, manuais e gerados pelo sistema, existe uma op\u00e7\u00e3o chamada <strong>Download<\/strong>.<\/p>\n<figure id=\"attachment_182474\" aria-describedby=\"caption-attachment-182474\" style=\"width: 1296px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-182474 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-backups-download.png\" alt=\"Iniciando um backup para download no MyKinsta.\" width=\"1296\" height=\"379\"><figcaption id=\"caption-attachment-182474\" class=\"wp-caption-text\">Iniciando um backup para download no MyKinsta.<\/figcaption><\/figure>\n<h4 class=\"has-anchor-hash\">Passo 1<\/h4>\n<p>Clique em <strong>Criar Backup Agora<\/strong>. Criar o backup pode levar v\u00e1rios minutos, dependendo do tamanho do seu site. Quando estiver pronto, voc\u00ea receber\u00e1 uma mensagem pelo painel do MyKinsta e tamb\u00e9m um <b>e-mail com um link de download<\/b>.<\/p>\n<figure id=\"attachment_171287\" aria-describedby=\"caption-attachment-171287\" style=\"width: 833px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-171287 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-backups-email.png\" alt=\"E-mail de notifica\u00e7\u00e3o de backup para download.\" width=\"833\" height=\"628\"><figcaption id=\"caption-attachment-171287\" class=\"wp-caption-text\">E-mail de notifica\u00e7\u00e3o de backup para download.<\/figcaption><\/figure>\n<h4 class=\"has-anchor-hash\">Passo 2<\/h4>\n<p>Clique no link <strong>Fazer o download do backup agora!<\/strong> No e-mail ou no bot\u00e3o <strong>Fazer o backup<\/strong>\u00a0no painel do MyKinsta.<\/p>\n<figure id=\"attachment_182475\" aria-describedby=\"caption-attachment-182475\" style=\"width: 1296px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-182475 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-backups-download-ready.png\" alt=\"Baixando um backup do WordPress no MyKinsta.\" width=\"1296\" height=\"379\"><figcaption id=\"caption-attachment-182475\" class=\"wp-caption-text\">Baixando um backup do WordPress no MyKinsta.<\/figcaption><\/figure>\n<p>O backup \u00e9 um arquivo <code>.zip file<\/code>. Ele cont\u00e9m todos os arquivos do seu website e um arquivo <code>mysql-database-backup.sql<\/code> Simplesmente <a href=\"https:\/\/kinsta.com\/pt\/blog\/descompactar-arquivo-zip\/\">descompacte-o<\/a> e voc\u00ea ter\u00e1 seu backup de banco de dados MySQL.<\/p>\n<figure id=\"attachment_49966\" aria-describedby=\"caption-attachment-49966\" style=\"width: 1250px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-49966 size-full\" src=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2017\/01\/arquivo-banco-dados-backup-mysql.jpg\" alt=\"Arquivo de banco de dados de backup do MySQL\" width=\"1250\" height=\"926\"><figcaption id=\"caption-attachment-49966\" class=\"wp-caption-text\">Arquivo de banco de dados de backup do MySQL<\/figcaption><\/figure>\n<h3>Fa\u00e7a o backup do seu banco de dados MySQL com backups externos<\/h3>\n<p>Nosso <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/backups-wordpress\/#external-backups-addon\">complemento externo de backups<\/a> permite que voc\u00ea configure <a href=\"https:\/\/kinsta.com\/pt\/blog\/backup-site-wordpress\/\">backups autom\u00e1ticos do site WordPress<\/a> para Amazon S3 ou Google Cloud Storage. Se voc\u00ea estiver procurando uma maneira conveniente de adicionar backups autom\u00e1ticos fora do site sem ter que instalar um plugin WordPress, nosso recurso de backups externos \u00e9 uma \u00f3tima op\u00e7\u00e3o.<\/p>\n<figure id=\"attachment_182471\" aria-describedby=\"caption-attachment-182471\" style=\"width: 1292px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-182471 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-backups-external-google.png\" alt=\"Op\u00e7\u00e3o do Google Cloud Storage sendo selecionada para backups externos.\" width=\"1292\" height=\"578\"><figcaption id=\"caption-attachment-182471\" class=\"wp-caption-text\">Op\u00e7\u00e3o do Google Cloud Storage sendo selecionada para backups externos.<\/figcaption><\/figure>\n<p>Para fazer backup do seu banco de dados MySQL com nossa op\u00e7\u00e3o de backups externos, certifique-se de que <strong>Banco de dados<\/strong> esteja selecionado durante o processo de configura\u00e7\u00e3o. (Todos os <strong>arquivos<\/strong> da instala\u00e7\u00e3o do WordPress tamb\u00e9m podem ser inclu\u00eddos.) Para mais informa\u00e7\u00f5es sobre como configurar backups externos para o seu site WordPress, consulte nossa <a href=\"https:\/\/kinsta.com\/pt\/docs\/hospedagem-de-wordpress\/backups-wordpress\/#external-backups-add-on\">documenta\u00e7\u00e3o de recursos<\/a>.<\/p>\n<figure id=\"attachment_171274\" aria-describedby=\"caption-attachment-171274\" style=\"width: 1604px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-171274 size-full\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/11\/wordpress-external-backup-choose-files.png\" alt=\"Selecionando op\u00e7\u00f5es para uma configura\u00e7\u00e3o de backup externo.\" width=\"1604\" height=\"902\"><figcaption id=\"caption-attachment-171274\" class=\"wp-caption-text\">Selecionando op\u00e7\u00f5es para uma configura\u00e7\u00e3o de backup externo.<\/figcaption><\/figure>\n<p>Se voc\u00ea est\u00e1 fazendo o backup para usar em outro lugar, confira nosso tutorial sobre como\u00a0<a href=\"https:\/\/kinsta.com\/pt\/blog\/como-restaurar-base-dados-mysql-phpmyadmin\/\" target=\"_blank\" rel=\"noopener noreferrer\">restaurar sua base de dados MySQL usando o phpMyAdmin<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Precisa de um backup de banco de dados MySQL? A maioria dos hosts WordPress, incluindo Kinsta, fazem backups automatizados, por isso n\u00e3o precisa de se preocupar &#8230;<\/p>\n","protected":false},"author":38,"featured_media":23999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[990],"class_list":["post-23992","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","topic-banco-de-dados-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.6 (Yoast SEO v24.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstapt\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/fm.brianleejackson\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-25T10:35:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T20:11:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1460\" \/>\n\t<meta property=\"og:image:height\" content=\"730\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brian Jackson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin\" \/>\n<meta name=\"twitter:description\" content=\"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\" \/>\n<meta name=\"twitter:creator\" content=\"@brianleejackson\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_pt\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jackson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\"},\"author\":{\"name\":\"Brian Jackson\",\"@id\":\"https:\/\/kinsta.com\/pt\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\"},\"headline\":\"Como Fazer o Backup da Base de Dados MySQL (2 M\u00e9todos Incrivelmente F\u00e1ceis)\",\"datePublished\":\"2019-02-25T10:35:19+00:00\",\"dateModified\":\"2025-10-01T20:11:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\"},\"wordCount\":1039,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/pt\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\",\"inLanguage\":\"pt-PT\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\",\"url\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\",\"name\":\"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\",\"datePublished\":\"2019-02-25T10:35:19+00:00\",\"dateModified\":\"2025-10-01T20:11:08+00:00\",\"description\":\"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\",\"contentUrl\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png\",\"width\":1460,\"height\":730},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Banco de dados MySQL\",\"item\":\"https:\/\/kinsta.com\/pt\/topicos\/banco-de-dados-mysql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Como Fazer o Backup da Base de Dados MySQL (2 M\u00e9todos Incrivelmente F\u00e1ceis)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/pt\/#website\",\"url\":\"https:\/\/kinsta.com\/pt\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Solu\u00e7\u00f5es de hospedagem Premium, r\u00e1pida e segura\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/pt\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/kinsta.com\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/pt\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/kinstapt\/\",\"https:\/\/x.com\/kinsta_pt\",\"https:\/\/www.instagram.com\/kinstahosting\/\",\"https:\/\/www.linkedin.com\/company\/kinsta\/\",\"https:\/\/www.pinterest.com\/kinstahosting\/\",\"https:\/\/www.youtube.com\/c\/Kinsta\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/kinsta.com\/pt\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\",\"name\":\"Brian Jackson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/kinsta.com\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"caption\":\"Brian Jackson\"},\"description\":\"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.\",\"sameAs\":[\"https:\/\/www.facebook.com\/fm.brianleejackson\",\"https:\/\/www.linkedin.com\/in\/brianleejackson\",\"https:\/\/x.com\/brianleejackson\"],\"url\":\"https:\/\/kinsta.com\/pt\/blog\/author\/brianjackson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin","description":"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.","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:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/","og_locale":"pt_PT","og_type":"article","og_title":"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin","og_description":"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.","og_url":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstapt\/","article_author":"https:\/\/www.facebook.com\/fm.brianleejackson","article_published_time":"2019-02-25T10:35:19+00:00","article_modified_time":"2025-10-01T20:11:08+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","type":"image\/png"}],"author":"Brian Jackson","twitter_card":"summary_large_image","twitter_title":"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin","twitter_description":"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.","twitter_image":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","twitter_creator":"@brianleejackson","twitter_site":"@kinsta_pt","twitter_misc":{"Escrito por":"Brian Jackson","Tempo estimado de leitura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/"},"author":{"name":"Brian Jackson","@id":"https:\/\/kinsta.com\/pt\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7"},"headline":"Como Fazer o Backup da Base de Dados MySQL (2 M\u00e9todos Incrivelmente F\u00e1ceis)","datePublished":"2019-02-25T10:35:19+00:00","dateModified":"2025-10-01T20:11:08+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/"},"wordCount":1039,"publisher":{"@id":"https:\/\/kinsta.com\/pt\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","inLanguage":"pt-PT"},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/","url":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/","name":"Como Fazer o Backup da Base de Dados MySQL Usando o phpMyAdmin","isPartOf":{"@id":"https:\/\/kinsta.com\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","datePublished":"2019-02-25T10:35:19+00:00","dateModified":"2025-10-01T20:11:08+00:00","description":"Talvez voc\u00ea queira um segundo backup ou precise migrar os hosts do WordPress. Confira este tutorial r\u00e1pido e f\u00e1cil sobre como fazer backup do banco de dados MySQL usando o phpMyAdmin.","breadcrumb":{"@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#primaryimage","url":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","contentUrl":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2019\/02\/fazer-backup-base-dados-mysql-usando-phpmyadmin.png","width":1460,"height":730},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/pt\/blog\/mysql-backup-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/pt\/"},{"@type":"ListItem","position":2,"name":"Banco de dados MySQL","item":"https:\/\/kinsta.com\/pt\/topicos\/banco-de-dados-mysql\/"},{"@type":"ListItem","position":3,"name":"Como Fazer o Backup da Base de Dados MySQL (2 M\u00e9todos Incrivelmente F\u00e1ceis)"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/pt\/#website","url":"https:\/\/kinsta.com\/pt\/","name":"Kinsta\u00ae","description":"Solu\u00e7\u00f5es de hospedagem Premium, r\u00e1pida e segura","publisher":{"@id":"https:\/\/kinsta.com\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/pt\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/kinsta.com\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/pt\/wp-content\/uploads\/sites\/3\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/pt\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kinstapt\/","https:\/\/x.com\/kinsta_pt","https:\/\/www.instagram.com\/kinstahosting\/","https:\/\/www.linkedin.com\/company\/kinsta\/","https:\/\/www.pinterest.com\/kinstahosting\/","https:\/\/www.youtube.com\/c\/Kinsta"]},{"@type":"Person","@id":"https:\/\/kinsta.com\/pt\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7","name":"Brian Jackson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/kinsta.com\/pt\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","caption":"Brian Jackson"},"description":"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.","sameAs":["https:\/\/www.facebook.com\/fm.brianleejackson","https:\/\/www.linkedin.com\/in\/brianleejackson","https:\/\/x.com\/brianleejackson"],"url":"https:\/\/kinsta.com\/pt\/blog\/author\/brianjackson\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/posts\/23992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/comments?post=23992"}],"version-history":[{"count":17,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/posts\/23992\/revisions"}],"predecessor-version":[{"id":72989,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/posts\/23992\/revisions\/72989"}],"alternate":[{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/es"},{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/it"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/fr"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/de"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/translations\/nl"},{"href":"https:\/\/kinsta.com\/pt\/wp-json\/kinsta\/v1\/posts\/23992\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/media\/23999"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/media?parent=23992"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/tags?post=23992"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/pt\/wp-json\/wp\/v2\/topic?post=23992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}