{"id":8096,"date":"2018-02-22T10:18:03","date_gmt":"2018-02-22T13:18:03","guid":{"rendered":"https:\/\/blog.hostinger.io\/br-tutoriais\/?p=8096"},"modified":"2026-06-08T09:50:04","modified_gmt":"2026-06-08T02:50:04","slug":"como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress","status":"publish","type":"post","link":"\/br\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/","title":{"rendered":"Como fazer uma busca e substitui\u00e7\u00e3o no banco de dados do WordPress"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Atualizar manualmente os registros do banco de dados pode tomar bastante tempo. A boa not&iacute;cia &eacute; que voc&ecirc; pode atualizar v&aacute;rios registros do banco de dados do WordPress de uma s&oacute; vez.<\/p><p class=\"wp-block-paragraph\">Neste tutorial de WordPress, voc&ecirc; vai aprender como fazer busca e substitui&ccedil;&atilde;o no banco de dados usando um plugin, o WP-CLI via SSH e uma consulta MySQL.<\/p><h2 class=\"wp-block-heading\" id=\"h-reasons-to-use-search-and-replace-on-a-wordpress-database\">Motivos para usar a busca e substitui&ccedil;&atilde;o no banco de dados do WordPress<\/h2><p class=\"wp-block-paragraph\">Como seu site depende do <a href=\"https:\/\/www.hostinger.com\/br\/tutoriais\/banco-de-dados-wordpress\/\">banco de dados do WordPress<\/a> para funcionar corretamente, vale a pena manter essas informa&ccedil;&otilde;es organizadas e atualizadas regularmente.<\/p><p class=\"wp-block-paragraph\">Confira algumas situa&ccedil;&otilde;es em que a busca e substitui&ccedil;&atilde;o pode ajudar:<\/p><ul class=\"wp-block-list\">\n<li><strong>Atualizar palavras-chave<\/strong> &ndash; o <a href=\"https:\/\/www.hostinger.com\/tutorials\/wordpress-seo-tips\/\">SEO <\/a>(en) est&aacute; sempre evoluindo, e palavras-chave que geravam resultados h&aacute; alguns meses podem perder relev&acirc;ncia com o tempo. Com a busca e substitui&ccedil;&atilde;o, voc&ecirc; consegue atualizar esses termos em massa de forma r&aacute;pida.<\/li>\n\n\n\n<li><strong>Corrigir erros de grafia e digita&ccedil;&atilde;o<\/strong> &ndash; pequenos erros de escrita podem passar despercebidos e acabar espalhados por v&aacute;rias p&aacute;ginas ou registros. Em vez de corrigi-los um por um, voc&ecirc; pode fazer tudo de uma s&oacute; vez.<\/li>\n\n\n\n<li><strong>Remover caracteres indesejados<\/strong> &ndash; em algumas situa&ccedil;&otilde;es, atualiza&ccedil;&otilde;es, migra&ccedil;&otilde;es ou problemas de codifica&ccedil;&atilde;o podem inserir caracteres ou s&iacute;mbolos inesperados no banco de dados. A busca e substitui&ccedil;&atilde;o facilita a limpeza dessas informa&ccedil;&otilde;es.<\/li>\n<\/ul><p class=\"wp-block-paragraph\">Independentemente do motivo, atualizar um banco de dados costuma envolver dezenas de tabelas e milhares de registros. Fazer esse trabalho manualmente pode consumir muito tempo e aumentar as chances de erros.<\/p><p class=\"wp-block-paragraph\">Por isso, a fun&ccedil;&atilde;o de busca e substitui&ccedil;&atilde;o do WordPress &eacute; t&atilde;o &uacute;til. Ela permite localizar informa&ccedil;&otilde;es espec&iacute;ficas no banco de dados e atualiz&aacute;-las rapidamente, tornando a manuten&ccedil;&atilde;o do site muito mais pr&aacute;tica.<\/p><p><strong><div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                Importante!<\/strong> Tenha em mente que n&atilde;o d&aacute; para desfazer nenhuma altera&ccedil;&atilde;o feita! Voc&ecirc; deve considerar <a href=\"\/br\/tutoriais\/como-fazer-backup-do-seu-site-wordpress\/\">fazer backup do seu site WordPress<\/a> antes de fazer qualquer altera&ccedil;&atilde;o no seu banco de dados para evitar uma poss&iacute;vel perda de dados.\n            <\/p><\/div><\/p><h2 class=\"wp-block-heading\" id=\"h-how-to-perform-search-and-replace-on-a-wordpress-database\">Como fazer uma busca e substitui&ccedil;&atilde;o no banco de dados do WordPress?<\/h2><p class=\"wp-block-paragraph\">Existem tr&ecirc;s maneiras de fazer uma busca e substitui&ccedil;&atilde;o no banco de dados do WordPress: usando um plugin, o WP-CLI via SSH ou uma consulta <a href=\"https:\/\/www.hostinger.com\/br\/tutoriais\/o-que-e-mysql\/\">MySQL<\/a>.<\/p><p class=\"wp-block-paragraph\">Um plugin &eacute; a op&ccedil;&atilde;o mais pr&aacute;tica para quem prefere trabalhar com uma interface visual. J&aacute; o WP-CLI &eacute; uma &oacute;tima alternativa para usu&aacute;rios com acesso SSH que desejam executar a tarefa em todo o banco de dados com um &uacute;nico comando. Por fim, as consultas MySQL oferecem mais controle sobre o processo, permitindo selecionar tabelas e campos espec&iacute;ficos para atualiza&ccedil;&atilde;o.<\/p><h3 class=\"wp-block-heading\" id=\"h-using-a-plugin\">Usando um plugin<\/h3><p class=\"wp-block-paragraph\">Esse m&eacute;todo &eacute; uma &oacute;tima op&ccedil;&atilde;o para quem prefere uma solu&ccedil;&atilde;o simples e pr&aacute;tica. Com um plugin, voc&ecirc; pode executar opera&ccedil;&otilde;es de busca e substitui&ccedil;&atilde;o quantas vezes precisar, sem editar c&oacute;digo manualmente.<\/p><p class=\"wp-block-paragraph\">Neste tutorial, vamos usar o <strong><a href=\"https:\/\/bettersearchreplace.com\/\" target=\"_blank\" rel=\"noopener\">Better Search Replace<\/a><\/strong>, um dos <a href=\"https:\/\/www.hostinger.com\/br\/tutoriais\/melhores-plugins-wordpress\/\">plugins mais populares<\/a> para realizar esse tipo de tarefa no WordPress.<\/p><p class=\"wp-block-paragraph\">Al&eacute;m da fun&ccedil;&atilde;o de busca e substitui&ccedil;&atilde;o, o Better Search Replace oferece recursos &uacute;teis para gerenciar o banco de dados, como backup e importa&ccedil;&atilde;o de dados.<\/p><p class=\"wp-block-paragraph\">Se o seu objetivo &eacute; apenas localizar e substituir informa&ccedil;&otilde;es, a vers&atilde;o gratuita &eacute; suficiente. J&aacute; quem precisa de recursos avan&ccedil;ados pode optar pela vers&atilde;o <a href=\"https:\/\/wordpress.org\/plugins\/better-search-replace\/\" target=\"_blank\" rel=\"noopener\">Pro<\/a>, com planos a partir de <strong>R$ 299 por ano<\/strong>.<\/p><ol class=\"wp-block-list\">\n<li>Para come&ccedil;ar, acesse <strong>Plugins &rarr; Adicionar novo<\/strong> no painel administrativo do WordPress.<\/li>\n\n\n\n<li>Em seguida, procure por <strong>Better Search Replace<\/strong> e clique em <strong>Instalar agora<\/strong>.<\/li>\n<\/ol><figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"473\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-plugins-addnew-bettersearchreplace-highlighted.png\/w=1024,h=1024,fit=scale-down\" alt=\"Os plugins adicionam uma nova se&ccedil;&atilde;o no painel do WordPress. O bot&atilde;o Instalar agora ao lado do plugin Better Search Replace est&aacute; destacado\" class=\"wp-image-55801\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-plugins-addnew-bettersearchreplace-highlighted.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-plugins-addnew-bettersearchreplace-highlighted.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-plugins-addnew-bettersearchreplace-highlighted.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-plugins-addnew-bettersearchreplace-highlighted.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><ol start=\"3\" class=\"wp-block-list\">\n<li>Clique no bot&atilde;o <strong>Ativar<\/strong> para ativar o plugin.<\/li>\n\n\n\n<li>No painel administrativo do WordPress, acesse <strong>Ferramentas<\/strong> -&gt; <strong>Better Search Replace<\/strong>.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">Na se&ccedil;&atilde;o <strong>Search\/Replace<\/strong>, voc&ecirc; precisar&aacute; inserir todos os itens a seguir:<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" width=\"835\" height=\"777\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/plugin-better-search-replace-3.png\/public\" alt=\"No plugin Better Search and Replace, preencha as informa&ccedil;&otilde;es do que voc&ecirc; quer buscar\" class=\"wp-image-55802\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/plugin-better-search-replace-3.png\/w=835,fit=scale-down 835w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/plugin-better-search-replace-3.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/plugin-better-search-replace-3.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/plugin-better-search-replace-3.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>A op&ccedil;&atilde;o <strong>Pesquisar<\/strong> deve conter a palavra ou express&atilde;o que voc&ecirc; quer alterar.<\/li>\n\n\n\n<li>&ldquo;<strong>Substituir por<\/strong>&rdquo; deve conter a palavra ou express&atilde;o que vai substituir o original.<\/li>\n\n\n\n<li>A fun&ccedil;&atilde;o <strong>Select tables<\/strong> permite escolher quais tabelas do seu banco de dados voc&ecirc; quer modificar.<\/li>\n\n\n\n<li><strong>Substituir GUIDs?<\/strong> permite substituir o n&uacute;mero do identificador global exclusivo (<a href=\"https:\/\/deliciousbrains.com\/wordpress-post-guids-sometimes-update\/\" target=\"_blank\" rel=\"noopener\">GUID<\/a>) dos dados modificados. Se o seu site j&aacute; estiver no ar, recomendamos que voc&ecirc; n&atilde;o marque esta caixa.<\/li>\n\n\n\n<li>Marque a op&ccedil;&atilde;o <strong>Executar como simula&ccedil;&atilde;o?<\/strong> se voc&ecirc; quiser revisar as altera&ccedil;&otilde;es antes de aplic&aacute;-las.<\/li>\n<\/ul><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Dica profissional                <\/p>\n            <\/div>\n            <p class=\"protip__content\">Se voc&ecirc; quiser selecionar todas as tabelas na coluna, pressione <strong>CTRL+A<\/strong>. Voc&ecirc; tamb&eacute;m pode selecionar tabelas individuais mantendo <strong>CTRL<\/strong> pressionado e clicando em uma tabela por vez. Se voc&ecirc; quiser fazer uma busca de dados sem diferenciar mai&uacute;sculas de min&uacute;sculas, marque a caixa <strong>Case-Insensitive?<\/strong>. <\/p>\n                    <\/div>\n        \n\n\n\n<\/p><p class=\"wp-block-paragraph\">Quando terminar, clique em <strong>Run Search\/Replace<\/strong>.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"847\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-ferramentas-bettersearchreplace-highlighted.png\/w=1024,h=1024,fit=scale-down\" alt=\"A mensagem de confirma&ccedil;&atilde;o do plugin Better Search Replace que aparece depois que voc&ecirc; executa com sucesso uma busca e substitui&ccedil;&atilde;o no banco de dados do WordPress.\" class=\"wp-image-55803\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-ferramentas-bettersearchreplace-highlighted.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-ferramentas-bettersearchreplace-highlighted.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-ferramentas-bettersearchreplace-highlighted.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/wpadmin-ferramentas-bettersearchreplace-highlighted.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Se voc&ecirc; executar o plugin sem a op&ccedil;&atilde;o de simula&ccedil;&atilde;o, ele far&aacute; altera&ccedil;&otilde;es no seu banco de dados imediatamente.<\/p><h3 class=\"wp-block-heading\"><strong>Usando o WP-CLI via SSH<\/strong> <\/h3><p class=\"wp-block-paragraph\"><a href=\"\/br\/tutoriais\/wp-cli\/\">WP-CLI<\/a> &eacute; uma ferramenta de linha de comando para gerenciar instala&ccedil;&otilde;es do WordPress. O comando de <strong>buscar e substituir<\/strong> faz uma varredura em todas as tabelas do banco de dados de uma s&oacute; vez, ent&atilde;o voc&ecirc; n&atilde;o precisa saber os nomes espec&iacute;ficos das tabelas ou dos campos.<\/p><p class=\"wp-block-paragraph\">Esse m&eacute;todo exige acesso via SSH e o WP-CLI instalado no seu servidor. Os planos de <a href=\"\/br\/wordpress-hosting\">hospedagem WordPress gerenciada da Hostinger<\/a> incluem os dois por padr&atilde;o.<\/p><p class=\"wp-block-paragraph\">Siga estas etapas para executar um search and replace com o WP-CLI:<\/p><ol class=\"wp-block-list\">\n<li>No hPanel, acesse <strong>Websites<\/strong> &rarr; <strong>Dashboard<\/strong> (ao lado do site que voc&ecirc; quer modificar) &rarr; <strong>Advanced<\/strong> &rarr; <strong>SSH Access<\/strong>.<\/li>\n\n\n\n<li>Se o <strong>status do SSH<\/strong> aparecer como <strong>INATIVO<\/strong>, clique em <strong>Ativar<\/strong> para habilitar o acesso SSH na sua conta.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a74b49fa3539\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a74b49fa3539\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"650\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hpanel-sites-acesso-ssh-avancado-habilitar-destacado.png\/w=1024,h=1024,fit=scale-down\" alt=\"O bot&atilde;o Ativar na p&aacute;gina Acesso SSH do hPanel\" class=\"wp-image-55804\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hpanel-sites-acesso-ssh-avancado-habilitar-destacado.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hpanel-sites-acesso-ssh-avancado-habilitar-destacado.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hpanel-sites-acesso-ssh-avancado-habilitar-destacado.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hpanel-sites-acesso-ssh-avancado-habilitar-destacado.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Na se&ccedil;&atilde;o <strong>Fazer login via SSH<\/strong>, o hPanel oferece duas op&ccedil;&otilde;es:\n<ul class=\"wp-block-list\">\n<li><strong>Use o terminal integrado do seu dispositivo<\/strong> &mdash; abra o <strong>Terminal<\/strong> (macOS\/Linux) ou o <strong>Prompt de Comando<\/strong>\/<strong>PowerShell<\/strong> (Windows) e cole o comando pronto exibido no hPanel. Fica mais ou menos assim:<\/li>\n<\/ul>\n<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ssh -p 65002 u123456789@185.185.185.185<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Use um cliente SSH<\/strong> &mdash; clique em <strong>PuTTY<\/strong> para baixar o cliente. Abra o PuTTY, digite o IP do servidor no campo <strong>Host Name<\/strong>, a porta no campo <strong>Port<\/strong>, selecione <strong>SSH<\/strong> como tipo de conex&atilde;o e clique em <strong>Open<\/strong>. Digite seu nome de usu&aacute;rio e sua senha quando a janela do terminal aparecer.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">Digite sua senha de SSH quando ela for solicitada.<\/p><ol start=\"4\" class=\"wp-block-list\">\n<li>Acesse o diret&oacute;rio raiz do WordPress. Na Hostinger, o caminho segue a estrutura de pastas dos <strong>dom&iacute;nios<\/strong>:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">cd domains\/domain.tld\/public_html<\/pre><p class=\"wp-block-paragraph\">Substitua <strong>domain.tld<\/strong> pelo seu nome de dom&iacute;nio real.<\/p><ol start=\"5\" class=\"wp-block-list\">\n<li>Primeiro, execute um teste para ver as altera&ccedil;&otilde;es antes de modificar o banco de dados:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">wp search-replace 'old-text' 'new-text' --dry-run<\/pre><p class=\"wp-block-paragraph\">Substitua <strong>old-text<\/strong> pela palavra ou frase que voc&ecirc; quer encontrar e <strong>new-text<\/strong> pelo texto que vai entrar no lugar. A flag <strong>&ndash;dry-run<\/strong> mostra quantas substitui&ccedil;&otilde;es seriam feitas em cada tabela sem execut&aacute;-las.<\/p><ol start=\"6\" class=\"wp-block-list\">\n<li>Revise o resultado. O WP-CLI exibe uma tabela com todas as tabelas do banco de dados afetadas e a quantidade de substitui&ccedil;&otilde;es encontradas.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a74b49fa6ac5\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a74b49fa6ac5\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"635\" height=\"1024\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/terminal-wp-search-replace-simulacao.png\/w=1024,h=1024,fit=scale-down\" alt=\"A tabela de sa&iacute;da do comando wp search-replace --dry-run\" class=\"wp-image-55805\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/terminal-wp-search-replace-simulacao.png\/w=635,fit=scale-down 635w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/terminal-wp-search-replace-simulacao.png\/w=186,fit=scale-down 186w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/terminal-wp-search-replace-simulacao.png\/w=93,fit=scale-down 93w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"7\" class=\"wp-block-list\">\n<li>Quando estiver satisfeito com os resultados, execute o comando sem a flag <strong>&ndash;dry-run<\/strong>:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">wp search-replace 'old-text' 'new-text'<\/pre><p class=\"wp-block-paragraph\">O WP-CLI processa todas as tabelas do banco de dados do WordPress por padr&atilde;o. Para incluir tabelas que n&atilde;o s&atilde;o do WordPress, como as criadas por plugins, adicione a flag <strong>&ndash;all-tables<\/strong>:<\/p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">wp search-replace 'old-text' 'new-text' --all-tables<\/pre><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Dica de especialista                <\/p>\n            <\/div>\n            <p class=\"protip__content\">O WP-CLI tamb&eacute;m lida corretamente com dados serializados, algo comum nas op&ccedil;&otilde;es do WordPress e nas configura&ccedil;&otilde;es de widgets. Os m&eacute;todos com plugin e MySQL podem corromper dados serializados se n&atilde;o forem usados com cuidado, o que faz do WP-CLI a op&ccedil;&atilde;o mais segura para substitui&ccedil;&otilde;es em todo o site, como mudan&ccedil;as de dom&iacute;nio.<\/p>\n                    <\/div>\n        \n\n\n<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"\/br\/hospedagem-wordpress\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2024\/06\/BR-New-WP_in-text-banner.png\/public\" alt=\"\" class=\"wp-image-44638\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2024\/06\/BR-New-WP_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2024\/06\/BR-New-WP_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2024\/06\/BR-New-WP_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2024\/06\/BR-New-WP_in-text-banner.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div><h3 class=\"wp-block-heading\" id=\"h-using-mysql-query\">Usando uma consulta MySQL<\/h3><p class=\"wp-block-paragraph\">Tamb&eacute;m d&aacute; para fazer uma busca e substitui&ccedil;&atilde;o no banco de dados do WordPress usando uma consulta MySQL pelo phpMyAdmin. <\/p><p class=\"wp-block-paragraph\">Primeiro, vamos ver como identificar o nome do banco de dados do seu WordPress, o que vale a pena ler se voc&ecirc; tiver mais de um banco de dados na sua conta. Em seguida, vamos ver como fazer uma busca e substitui&ccedil;&atilde;o no banco de dados.<\/p><p class=\"wp-block-paragraph\">Veja como encontrar o nome do banco de dados do seu WordPress:<\/p><ol class=\"wp-block-list\">\n<li>Acesse a se&ccedil;&atilde;o <strong>Gerenciador de Arquivos<\/strong> no painel do hPanel.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a74b49fad6ea\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a74b49fad6ea\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"509\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/dashboard-do-hPanel.png\/w=1024,h=1024,fit=scale-down\" alt=\"Painel do hPanel, com destaque para o acesso ao Gerenciador de Arquivos\" class=\"wp-image-55806\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/dashboard-do-hPanel.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/dashboard-do-hPanel.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/dashboard-do-hPanel.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/dashboard-do-hPanel.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"2\" class=\"wp-block-list\">\n<li>Acesse a pasta <strong>public_html<\/strong> e d&ecirc; um clique duplo no arquivo <strong>wp-config.php<\/strong> para abri-lo.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a74b49fb002b\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a74b49fb002b\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"366\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-raiz.png\/w=1024,h=1024,fit=scale-down\" alt=\"Gerenciador de Arquivos da Hostinger destacando o arquivo wp-config.php\" class=\"wp-image-55807\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-raiz.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-raiz.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-raiz.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-raiz.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Localize o valor de <strong>DB_NAME<\/strong>. O nome do seu banco de dados do WordPress &eacute; o valor que aparece ao lado dele. Neste exemplo, o nome &eacute; &ldquo;database-name-example.&rdquo;<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a74b49fb2c27\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a74b49fb2c27\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"992\" height=\"950\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-wp-config.png\/public\" alt=\"Editor do Gerenciador de Arquivos da Hostinger, destacando o nome do banco de dados no wp-config\" class=\"wp-image-55808\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-wp-config.png\/w=992,fit=scale-down 992w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-wp-config.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-wp-config.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hostinger-gerenciador-de-arquivos-wp-config.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 992px) 100vw, 992px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Nosso tutorial sobre como encontrar o nome do banco de dados do WordPress traz mais informa&ccedil;&otilde;es e mostra o passo a passo usando um cliente FTP.<\/p><p class=\"wp-block-paragraph\">Depois de identificar o nome do banco de dados, siga estas etapas para fazer uma busca e substitui&ccedil;&atilde;o no banco de dados:<\/p><ol class=\"wp-block-list\">\n<li>No painel do hPanel, acesse <strong>Databases<\/strong> &rarr; <strong>phpMyAdmin<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"442\" height=\"298\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-databases-phpmyadmin-sidebar.png\/public\" alt=\"O bot&atilde;o do phpMyAdmin na se&ccedil;&atilde;o Bancos de dados do hPanel\" class=\"wp-image-55809\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-databases-phpmyadmin-sidebar.png\/w=442,fit=scale-down 442w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-databases-phpmyadmin-sidebar.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-databases-phpmyadmin-sidebar.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/figure>\n<\/div><ol start=\"2\" class=\"wp-block-list\">\n<li>Localize o banco de dados do WordPress e selecione <strong>Acessar phpMyAdmin<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"427\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-bancos-de-dados-phpMyAdmin-enterphpmyadmin-destacado.png\/w=1024,h=1024,fit=scale-down\" alt=\"A se&ccedil;&atilde;o phpMyAdmin no hPanel. O bot&atilde;o Enter phpMyAdmin est&aacute; destacado\" class=\"wp-image-55810\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-bancos-de-dados-phpMyAdmin-enterphpmyadmin-destacado.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-bancos-de-dados-phpMyAdmin-enterphpmyadmin-destacado.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-bancos-de-dados-phpMyAdmin-enterphpmyadmin-destacado.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/hPanel-bancos-de-dados-phpMyAdmin-enterphpmyadmin-destacado.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Na p&aacute;gina do <strong>phpMyAdmin<\/strong>, acesse a aba <strong>SQL<\/strong> na barra de menu superior.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"421\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/Captura-de-tela-2023-01-26-as-165856.png\/w=1024,h=1024,fit=scale-down\" alt=\"Acessando a p&aacute;gina do phpMyAdmin, guia SQL na barra de menu superior\" class=\"wp-image-55811\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/Captura-de-tela-2023-01-26-as-165856.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/Captura-de-tela-2023-01-26-as-165856.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/Captura-de-tela-2023-01-26-as-165856.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/53\/2026\/06\/Captura-de-tela-2023-01-26-as-165856.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><ol start=\"4\" class=\"wp-block-list\">\n<li>Adicione o trecho de c&oacute;digo abaixo no espa&ccedil;o dispon&iacute;vel<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'Text to search, 'Text to replace it with');<\/pre><p class=\"wp-block-paragraph\">N&atilde;o se esque&ccedil;a de substituir os textos de preenchimento pelas informa&ccedil;&otilde;es corretas:<\/p><ul class=\"wp-block-list\">\n<li><strong>TABLE_NAME<\/strong> representa o nome da tabela que voc&ecirc; quer modificar.<\/li>\n\n\n\n<li><strong>FIELD_NAME<\/strong> representa o nome do campo\/coluna onde os dados desejados est&atilde;o armazenados.<\/li>\n\n\n\n<li><em><strong>&lsquo;Text to search&rsquo;<\/strong> <\/em>cont&eacute;m a palavra ou frase que voc&ecirc; quer alterar.<\/li>\n\n\n\n<li><strong><em>&lsquo;Text to replace it with<\/em>&rsquo;<\/strong> cont&eacute;m a palavra ou express&atilde;o que vai substituir o texto anterior.<\/li>\n<\/ul><p class=\"wp-block-paragraph\">Depois de escrever a consulta, clique no bot&atilde;o <strong>Go <\/strong>para execut&aacute;-la.<\/p><h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclus&atilde;o<\/h2><p class=\"wp-block-paragraph\">Para manter seu site em WordPress funcionando bem e sempre atualizado, voc&ecirc; precisa fazer a manuten&ccedil;&atilde;o do banco de dados periodicamente. A manuten&ccedil;&atilde;o inclui substituir dados desatualizados. Fica muito mais f&aacute;cil resolver isso em massa com a ajuda de uma opera&ccedil;&atilde;o de buscar e substituir no WordPress.<\/p><p class=\"wp-block-paragraph\">Existem tr&ecirc;s formas de fazer uma busca e substitui&ccedil;&atilde;o no banco de dados do WordPress: <\/p><ol class=\"wp-block-list\">\n<li><strong>Usando o plugin Better Search Replace<\/strong> &ndash; ideal para quem n&atilde;o tem experi&ecirc;ncia com programa&ccedil;&atilde;o.<\/li>\n\n\n\n<li><strong>Usando o WP-CLI via SSH<\/strong>: um &uacute;nico comando que abrange todas as tabelas do banco de dados sem exigir que voc&ecirc; saiba os nomes espec&iacute;ficos das tabelas.<\/li>\n\n\n\n<li><strong>Usando uma consulta MySQL<\/strong> &mdash; ideal para quem tem conhecimento t&eacute;cnico de n&iacute;vel intermedi&aacute;rio a avan&ccedil;ado e precisa segmentar tabelas espec&iacute;ficas.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">Qual m&eacute;todo voc&ecirc; prefere? Conte para a gente nos coment&aacute;rios abaixo!<\/p><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Conhe&ccedil;a outras t&eacute;cnicas avan&ccedil;adas de WordPress                <\/p>\n            <\/div>\n            <p class=\"protip__content\"><a href=\"\/br\/tutoriais\/velocidade-do-site\/\">Como acelerar o WordPress<\/a> <a href=\"\/br\/tutoriais\/como-desenvolver-no-wordpress\/\">Como se tornar um desenvolvedor WordPress<\/a> <a href=\"\/br\/tutoriais\/wp_query\/\">Como usar o WP_Query no WordPress<\/a> Como usar o XAMPP para configurar um site WordPress local Como adicionar CSS personalizado ao WordPress <a href=\"\/br\/tutoriais\/como-ativar-multisite-wordpress\/\">Tudo sobre WordPress Multisite<\/a><\/p>\n                    <\/div>\n        \n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-wordpress-search-and-replace-faq\">Perguntas frequentes sobre busca e substitui&ccedil;&atilde;o no WordPress<\/h2><p class=\"wp-block-paragraph\">Estas s&atilde;o as d&uacute;vidas mais comuns sobre busca e substitui&ccedil;&atilde;o no WordPress.<\/p><div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1780376562108\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Como pesquisar e substituir conte&uacute;do no WordPress?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Para pesquisar e substituir conte&uacute;do no WordPress, voc&ecirc; pode usar o plugin Better Search Replace, que permite encontrar e substituir textos espec&iacute;ficos no banco de dados do seu site em WordPress. Voc&ecirc; tamb&eacute;m pode usar o WP-CLI via SSH, que processa todas as tabelas do banco de dados com um &uacute;nico comando. Como alternativa, voc&ecirc; pode executar uma consulta MySQL no phpMyAdmin para acessar tabelas e campos espec&iacute;ficos.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1780376563915\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Com que frequ&ecirc;ncia devo buscar e substituir dados desatualizados no WordPress?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Recomendamos buscar e substituir dados desatualizados no WordPress sempre que necess&aacute;rio, como ao atualizar o design do seu site, mudar o nome de dom&iacute;nio ou migrar o site para um novo servidor. Al&eacute;m disso, voc&ecirc; tamb&eacute;m pode revisar periodicamente o banco de dados do seu site para remover dados desnecess&aacute;rios.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Atualizar manualmente os registros do banco de dados pode tomar bastante tempo. A boa not&iacute;cia &eacute; que voc&ecirc; pode atualizar v&aacute;rios registros do banco de dados do WordPress de uma s&oacute; vez. Neste tutorial de WordPress, voc&ecirc; vai aprender como fazer busca e substitui&ccedil;&atilde;o no banco de dados usando um plugin, o WP-CLI via SSH [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/br\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":473,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rank_math_title":"Como fazer mudan\u00e7as no banco de dados do WordPress","rank_math_description":"Quer trocar de URL, substituir palavras no site ou fazer outras altera\u00e7\u00f5es no seu banco de dados do wordpress?","rank_math_focus_keyword":"banco de dados do wordpress","footnotes":""},"categories":[8065,8027],"tags":[4833,5249,4798],"class_list":["post-8096","post","type-post","status-publish","format-standard","hentry","category-seguranca-e-manutencao","category-wordpress","tag-banco-de-dados","tag-procurar-e-substituir","tag-wordpress"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":1},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-search-and-replace-database-wordpress\/","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/","default":0}],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/posts\/8096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/users\/473"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/comments?post=8096"}],"version-history":[{"count":8,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/posts\/8096\/revisions"}],"predecessor-version":[{"id":56109,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/posts\/8096\/revisions\/56109"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/media?parent=8096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/categories?post=8096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/tutoriais\/wp-json\/wp\/v2\/tags?post=8096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}