Hello! I moved the site to a subdomain, everything works except the images uploaded earlier, how to solve the problem?

Question

The site is on the same server.

Answer 1

What precisely doesn’t work? Are the image URLs still using the old domain? In which case you’ll need to update them all to use the subdomain.

You might be able to do a search & replace within the qa_posts table to change them.

Comments

Yes, but there are thousands of photos, how do you imagine it?

---

Look up the REPLACE function in MySQL. Depending on how exactly the content is formatted (e.g. whether it’s HTML) you may be able to do something like:

UPDATE qa_posts SET content = REPLACE(content, '<img src="http://example.com/', '<img src="http://sub.example.com/')

Note: I haven’t tested this so double check and make a backup before running.