WordPress.org

Support

Support » Plugins and Hacks » SQL query deleting file urls

SQL query deleting file urls

  • sta777
    Member

    @sta777

    When moving a local site to a live site, the file urls for all of my downloads get deleted when running sql queries to update wp_postmeta.

    The only way I can move my site without having all of the file urls removed is by manually changing each of them to the new url once I have moved the site.

    The exact query is below:
    UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘http://localhost/sitename’, ‘http://www.sitename.co.uk’);

    Surely this shouldn’t happen?

    http://wordpress.org/plugins/download-monitor/

Viewing 2 replies - 1 through 2 (of 2 total)
  • I’m having the same problem. I search and replace the SQL file on my text editor and when I upload my database I have the same problem, the file urls are deleted…

    Have you found a solution?

    Thanks!!

    Hahaha not really; end up manually changing the file urls to the new address first, then doing the sql replaces.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL query deleting file urls’ is closed to new replies.