Support » Plugin: Download Monitor » SQL query deleting file urls

  • 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’, ‘’);

    Surely this shouldn’t happen?

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?


    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.