• Risolto Luigi Amorfini

    (@lamorfini)


    Salve, non riesco ad cambiare gli url del mio sito che è online e vorrei fare una copia in locale per far prove prima di mettere le cose online.
    Quindi sto usando questo:
    https://github.com/wp-cli/search-replace-command
    in questo modo:
    wp search-replace 'http://www.miositoweb.it' 'http://localhost:81' --all-tables
    mi da come output:

    +------------------+-----------------------+--------------+------+
    | Table            | Column                | Replacements | Type |
    +------------------+-----------------------+--------------+------+
    | wp_commentmeta   | meta_key              | 0            | SQL  |
    | wp_commentmeta   | meta_value            | 0            | SQL  |
    | wp_comments      | comment_author        | 0            | SQL  |
    | wp_comments      | comment_author_email  | 0            | SQL  |
    | wp_comments      | comment_author_url    | 0            | SQL  |
    | wp_comments      | comment_author_IP     | 0            | SQL  |
    | wp_comments      | comment_content       | 0            | SQL  |
    | wp_comments      | comment_approved      | 0            | SQL  |
    | wp_comments      | comment_agent         | 0            | SQL  |
    | wp_comments      | comment_type          | 0            | SQL  |
    | wp_links         | link_url              | 0            | SQL  |
    | wp_links         | link_name             | 0            | SQL  |
    | wp_links         | link_image            | 0            | SQL  |
    | wp_links         | link_target           | 0            | SQL  |
    | wp_links         | link_description      | 0            | SQL  |
    | wp_links         | link_visible          | 0            | SQL  |
    | wp_links         | link_rel              | 0            | SQL  |
    | wp_links         | link_notes            | 0            | SQL  |
    | wp_links         | link_rss              | 0            | SQL  |
    | wp_options       | option_name           | 0            | SQL  |
    | wp_options       | option_value          | 0            | PHP  |
    | wp_options       | autoload              | 0            | SQL  |
    | wp_postmeta      | meta_key              | 0            | SQL  |
    | wp_postmeta      | meta_value            | 0            | PHP  |
    | wp_posts         | post_content          | 0            | SQL  |
    | wp_posts         | post_title            | 0            | SQL  |
    | wp_posts         | post_excerpt          | 0            | SQL  |
    | wp_posts         | post_status           | 0            | SQL  |
    | wp_posts         | comment_status        | 0            | SQL  |
    | wp_posts         | ping_status           | 0            | SQL  |
    | wp_posts         | post_password         | 0            | SQL  |
    | wp_posts         | post_name             | 0            | SQL  |
    | wp_posts         | to_ping               | 0            | SQL  |
    | wp_posts         | pinged                | 0            | SQL  |
    | wp_posts         | post_content_filtered | 0            | SQL  |
    | wp_posts         | guid                  | 0            | SQL  |
    | wp_posts         | post_type             | 0            | SQL  |
    | wp_posts         | post_mime_type        | 0            | SQL  |
    | wp_ratings       | rating_posttitle      | 0            | SQL  |
    | wp_ratings       | rating_timestamp      | 0            | SQL  |
    | wp_ratings       | rating_ip             | 0            | SQL  |
    | wp_ratings       | rating_host           | 0            | SQL  |
    | wp_ratings       | rating_username       | 0            | SQL  |
    | wp_term_taxonomy | taxonomy              | 0            | SQL  |
    | wp_term_taxonomy | description           | 0            | SQL  |
    | wp_termmeta      | meta_key              | 0            | SQL  |
    | wp_termmeta      | meta_value            | 0            | SQL  |
    | wp_terms         | name                  | 0            | SQL  |
    | wp_terms         | slug                  | 0            | SQL  |
    | wp_usermeta      | meta_key              | 0            | SQL  |
    | wp_usermeta      | meta_value            | 0            | PHP  |
    | wp_users         | user_login            | 0            | SQL  |
    | wp_users         | user_nicename         | 0            | SQL  |
    | wp_users         | user_email            | 0            | SQL  |
    | wp_users         | user_url              | 0            | SQL  |
    | wp_users         | user_activation_key   | 0            | SQL  |
    | wp_users         | display_name          | 0            | SQL  |
    | wp_wppa_albums   | name                  | 0            | SQL  |
    | wp_wppa_albums   | description           | 0            | SQL  |
    | wp_wppa_albums   | cover_linktype        | 0            | SQL  |
    | wp_wppa_albums   | owner                 | 0            | SQL  |
    | wp_wppa_albums   | timestamp             | 0            | SQL  |
    | wp_wppa_albums   | modified              | 0            | SQL  |
    | wp_wppa_albums   | upload_limit          | 0            | SQL  |
    | wp_wppa_albums   | alt_thumbsize         | 0            | SQL  |
    | wp_wppa_albums   | default_tags          | 0            | SQL  |
    | wp_wppa_albums   | cover_type            | 0            | SQL  |
    | wp_wppa_albums   | suba_order_by         | 0            | SQL  |
    | wp_wppa_albums   | cats                  | 0            | SQL  |
    | wp_wppa_albums   | scheduledtm           | 0            | SQL  |
    | wp_wppa_albums   | custom                | 0            | SQL  |
    | wp_wppa_albums   | crypt                 | 0            | SQL  |
    | wp_wppa_albums   | treecounts            | 0            | PHP  |
    | wp_wppa_albums   | wmfile                | 0            | SQL  |
    | wp_wppa_albums   | wmpos                 | 0            | SQL  |
    | wp_wppa_albums   | indexdtm              | 0            | SQL  |
    | wp_wppa_comments | timestamp             | 0            | SQL  |
    | wp_wppa_comments | user                  | 0            | SQL  |
    | wp_wppa_comments | ip                    | 0            | SQL  |
    | wp_wppa_comments | email                 | 0            | SQL  |
    | wp_wppa_comments | comment               | 0            | SQL  |
    | wp_wppa_comments | status                | 0            | SQL  |
    | wp_wppa_exif     | tag                   | 0            | SQL  |
    | wp_wppa_exif     | description           | 0            | SQL  |
    | wp_wppa_exif     | status                | 0            | SQL  |
    | wp_wppa_exif     | f_description         | 0            | SQL  |
    | wp_wppa_exif     | brand                 | 0            | SQL  |
    | wp_wppa_index    | slug                  | 0            | SQL  |
    | wp_wppa_index    | albums                | 0            | SQL  |
    | wp_wppa_index    | photos                | 0            | SQL  |
    | wp_wppa_iptc     | tag                   | 0            | SQL  |
    | wp_wppa_iptc     | description           | 0            | SQL  |
    | wp_wppa_iptc     | status                | 0            | SQL  |
    | wp_wppa_photos   | ext                   | 0            | SQL  |
    | wp_wppa_photos   | name                  | 0            | SQL  |
    | wp_wppa_photos   | description           | 0            | SQL  |
    | wp_wppa_photos   | mean_rating           | 0            | SQL  |
    | wp_wppa_photos   | linkurl               | 0            | SQL  |
    | wp_wppa_photos   | linktitle             | 0            | SQL  |
    | wp_wppa_photos   | linktarget            | 0            | SQL  |
    | wp_wppa_photos   | owner                 | 0            | SQL  |
    | wp_wppa_photos   | timestamp             | 0            | SQL  |
    | wp_wppa_photos   | status                | 0            | SQL  |
    | wp_wppa_photos   | tags                  | 0            | SQL  |
    | wp_wppa_photos   | alt                   | 0            | SQL  |
    | wp_wppa_photos   | filename              | 0            | SQL  |
    | wp_wppa_photos   | modified              | 0            | SQL  |
    | wp_wppa_photos   | location              | 0            | SQL  |
    | wp_wppa_photos   | exifdtm               | 0            | SQL  |
    | wp_wppa_photos   | scheduledtm           | 0            | SQL  |
    | wp_wppa_photos   | scheduledel           | 0            | SQL  |
    | wp_wppa_photos   | custom                | 0            | SQL  |
    | wp_wppa_photos   | crypt                 | 0            | SQL  |
    | wp_wppa_photos   | magickstack           | 0            | SQL  |
    | wp_wppa_photos   | indexdtm              | 0            | SQL  |
    | wp_wppa_rating   | timestamp             | 0            | SQL  |
    | wp_wppa_rating   | user                  | 0            | SQL  |
    | wp_wppa_rating   | status                | 0            | SQL  |
    | wp_wppa_session  | session               | 0            | SQL  |
    | wp_wppa_session  | timestamp             | 0            | SQL  |
    | wp_wppa_session  | user                  | 0            | SQL  |
    | wp_wppa_session  | ip                    | 0            | SQL  |
    | wp_wppa_session  | status                | 0            | SQL  |
    | wp_wppa_session  | data                  | 0            | PHP  |
    +------------------+-----------------------+--------------+------+
    Success: Made 0 replacements.

    come mai non mi fa il replace del sito ?. vi ringrazio in anticipo e buona serata spero che risolvete il mio problema.

    Il nome del sito qui lo nascosto.. quindi vorrei sapere come mai fa cosi.
    Grazie mille e buona serata.

Stai visualizzando 2 risposte - dal 1 al 2 (di 2 totali)
Stai visualizzando 2 risposte - dal 1 al 2 (di 2 totali)
  • Il topic ‘da host a locale (wp cli ) search-replace’ è chiuso a nuove risposte.