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

Exportar/Importar Base de Datos WordPress 2026

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

Cómo validamos estos pasos

Antes de publicar reproducimos cada paso en al menos dos marcas si depende del proveedor. o dos veces en días distintos si no. Capturamos errores de consola, etiquetas que cambian por región y actualizamos si mueven un botón. Rutas y capturas se revisan trimestralmente. En DNS, SSL o pagos verificamos opciones de recuperación y enlazamos la documentación 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.
★★★★½
✓ Ventajas
  • 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.
✕ Inconvenientes
  • SiteGround menu labels change. Look for the idea, not one fixed menu path.
  • No free domain included.
Precio/mes$3.99
Almacenamiento10 GB SSD
Dominio Gratis✕ No
Disponibilidad99.99%
9.8 /10
Ver Oferta SiteGround →
Leer análisis completo
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.
★★★★½
✓ Ventajas
  • 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.
✕ Inconvenientes
  • DreamHost menu labels change. Look for the idea, not one fixed menu path.
  • No classic phone support on many plans. Chat and callbacks only.
Precio/mes$2.59
AlmacenamientoUnlimited SSD
Dominio Gratis✓ Sí
Disponibilidad100%
9.2 /10
Ver Oferta DreamHost →
Leer análisis completo

Preguntas Frecuentes

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.