Alex Morgan
Alex Morgan
Senior Hosting Analyst
10+ years testing web hosting infrastructure. Benchmarks servers across 4 continents.
WordPress-хостинг

Экспорт/импорт БД WordPress 2026

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

Как мы проверяли эти шаги

Перед публикацией прогоняем каждый шаг минимум на двух брендах, если он зависит от хостера,. или дважды в разные дни на одном стеке. Пишем ошибки консоли, расхождения UI по регионам и обновляем текст, если перенесли кнопку. Пути и скриншоты ревьюим ежеквартально. Для DNS/SSL/оплаты проверяем варианты отката и ссылаемся на официальные доки.

  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.
★★★★½
✓ Плюсы
  • 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.
✕ Минусы
  • SiteGround menu labels change. Look for the idea, not one fixed menu path.
  • No free domain included.
Цена/мес$3.99
Хранилище10 GB SSD
Бесплатный домен✕ Нет
Доступность99.99%
9.8 /10
Получить предложение SiteGround →
Читать полный обзор
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.
★★★★½
✓ Плюсы
  • 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.
✕ Минусы
  • DreamHost menu labels change. Look for the idea, not one fixed menu path.
  • No classic phone support on many plans. Chat and callbacks only.
Цена/мес$2.59
ХранилищеUnlimited SSD
Бесплатный домен✓ Да
Доступность100%
9.2 /10
Получить предложение DreamHost →
Читать полный обзор

Часто задаваемые вопросы

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.