Hébergement WordPress Aide

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, 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


Cet article était-il utile ?
Nous vous remercions de votre feed-back. Pour parler avec un représentant de notre service clientèle, veuillez utiliser le numéro de téléphone du support technique ou l’option de chat présentée ci-dessus.
Nous sommes ravis de vous avoir aidé ! Y a-t-il autre chose que nous pouvons faire pour vous ?
Nous sommes désolés de ce problème. Dites-nous ce qui n’était pas clair ou pourquoi la solution n’a pas résolu votre problème.