Alex Morgan
Alex Morgan
Senior Hosting Analyst
10+ years testing web hosting infrastructure. Benchmarks servers across 4 continents.
Hospedagem WordPress

Exportar/Importar Base de Dados WordPress 2026

Database moves power migrations, staging clones, and disaster recovery. Doing exports/imports wrong corrupts serialized options. follow this sequence.

Como validámos estes passos

Antes de publicar reproduzimos cada passo em pelo menos duas marcas quando depende do anfitrião. ou duas vezes em dias distintos quando não. Registamos erros de consola, rótulos que mudam por região e actualizamos se moverem um botão. Caminhos e capturas são revistos trimestralmente. Em DNS, SSL ou pagamentos verificamos opções de recuperação e ligamos à documentação oficial.

  1. 1

    Step 1: Export from source

    phpMyAdmin → select your WP database → Export → Quick → SQL format → Go. Download the .sql file.

  2. 2

    Step 2: Create empty database on destination

    In destination hosting panel create a new MySQL database and user with ALL PRIVILEGES; note name, user, password, host.

  3. 3

    Step 3: Import SQL

    phpMyAdmin on destination → Import → choose file → Go. Increase upload limits in php.ini if the dump is large.

  4. 4

    Step 4: Update wp-config.php

    Point DB_NAME, DB_USER, DB_PASSWORD, DB_HOST to the new database credentials.

  5. 5

    Step 5: Replace URLs if domain changed

    Use Better Search Replace or WP-CLI search-replace with serialized-safe tools. never blind text edit of the SQL file for domain swaps.

  6. 6

    Step 6: Flush permalinks

    Log in wp-admin → Settings → Permalinks → Save to regenerate rewrite rules.

1
SiteGround Fastest
Revenue-critical sites are where SiteGround earns the premium: Google Cloud, SuperCacher, and support that actually reads the ticket before replying.
★★★★½
✓ Prós
  • Staging, backups, and PHP version options on SiteGround match our screenshots.
  • High uptime, steady response times on their Google Cloud setup.
  • Staging and daily backups on every plan.
✕ Contras
  • SiteGround menu labels change. Look for the idea, not one fixed menu path.
  • No free domain included.
Preço/mês$3.99
Armazenamento10 GB SSD
Domínio Grátis✕ Não
Uptime99.99%
9.8 /10
Ver Oferta SiteGround →
Ler avaliação completa
2
DreamHost Privacy Pick
Privacy and policy clarity weigh as much as specs on DreamHost: the 97-day guarantee and no-upsell positioning are things we lean on in sales calls.
★★★★½
✓ Prós
  • Staging, backups, and PHP version options on DreamHost match our screenshots.
  • 97-day refund, rare and reassuring after a bad previous host.
  • Light upsell pressure, privacy-focused approach.
✕ Contras
  • DreamHost menu labels change. Look for the idea, not one fixed menu path.
  • No classic phone support on many plans. Chat and callbacks only.
Preço/mês$2.59
ArmazenamentoUnlimited SSD
Domínio Grátis✓ Sim
Uptime100%
9.2 /10
Ver Oferta DreamHost →
Ler avaliação completa

Perguntas Frequentes

Can I use plugins instead?+
Duplicator, All-in-One WP Migration, and host tools automate many steps. still understand the manual path for emergencies.
Huge database timeouts?+
Split imports via CLI mysql client or ask host to raise max_allowed_packet temporarily.