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.

我们如何核对文中步骤

发布前，若步骤依赖主机商，我们会在至少两家平台各走一遍；否则在同一环境隔日执行两次。我们记录控制台报错、不同地区的界面文案差异，并在厂商调整按钮位置后立即更新文案。路径与截图每季度抽检。涉及 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.