略過並前往主要內容
致電我們
服務專線和服務時間
預約回電

無須線上等候,提交預約我們將儘快回電。

預約回電
說明中心

瀏覽我們線上說明資源

說明

Managed WordPress 說明

Update the site database

Note: This is the fourth step in manually migrating a WordPress site to your Pro Managed WordPress account. If you don't have a Pro Managed WordPress account, you can learn more about them here.

Part 1: Copy the wp-content folder Part 2: Make an SQL dump file
Part 3: Upload the site content Part 4: Update the site database
Part 5: Change the table prefixes Part 6: Make final edits

The next step you need to complete to manually migrate a WordPress site to a Pro Managed WordPress account: Update the WordPress site database. We'll use phpMyAdmin to get this done. Give yourself five to ten minutes to complete this part.

  1. Go to the Settings page for the new Pro Managed WordPress site:
    1. In your My Products page, next to Managed WordPress, click Manage All.
    2. Click the three-dot icon for the Pro Managed WordPress site and select Settings.
  2. In the Settings section, next to phpMyAdmin click Open. We'll take you straight to the phpMyAdmin main page for the site.
    open phpmyadmin
  3. Click the site database in the list (probably looks like wp_[long-file-name]).
    select database
  4. A list of database tables appears on the right. Scroll to the bottom of the list, select Check all, and then select Drop in the menu on the right.
    check all and choose drop
  5. When you're asked Do you really want to execute the following query?, click Yes. The application removes the tables from the database.
  6. In the top menu bar, click Import.
    click import
  7. Click Choose File, browse to the .sql file you saved in an earlier step, and double-click to select it.
    choose file to import
  8. Click Go. The application imports your SQL dump file and repopulates the list of tables.
  9. Click the plus sign next to the database name to see the list of tables in the database, and look at the name of the first table in the list.
    look at table names

    In this example the table name is abc123_commentmeta.

    The table prefix is all the characters in the table name up to but not including the last underscore ( _ ) character. The table prefix here is abc123. If the table name was wp_123_456_789_commentmeta, then the table prefix would be wp_123_456_789.

    • If the table prefix is not wp (for example, if the table name is wp_abc123_commentmeta), you do need to change some code. Copy the table prefix and continue with Part 5.
    • If the table prefix is wp (for example, if the table name is wp_commentmeta), you don't need to change any code. Continue with Part 6.

Next step

More info

相關社群

quickcrepes's Avatar
500 Error with newly migrated WordPress site.

1 回覆

Last posted almost 4 years ago.

mikeb1's Avatar
Connecting to mySQL database

5 回覆

Last posted about 1 year ago.

bdp31770's Avatar
Can't log in to Wordpress without updating database

2 回覆

Last posted 10 months ago.

JOYBHATTACHARYA's Avatar
MS Access database became read-only

2 回覆

Last posted over 4 years ago.

找不到主題嗎?搜尋社群