WordPress - MySQL - replace domain for all pdf links in database.

Outdoor · September 2023

Hello there,

We have a website with a huge number of PDF documents.

All PDFs are moved to a new location (v2.domain.com ) and everything else stays at the original location (domain.com).

How can I update the database to change the domain for all links that contain PDF?

domain.compdf replace with v2.domain.compdf?

We use Ubuntu, I have key help with phpmyadmin.

Is it better to do it via some plugin or via MySQL query?
Can you please help me with query?

I have tried:

UPDATE wp_posts
SET post_content = REPLACE(post_content, 'http://domain.com', 'http://v2.domain.com')
WHERE post_content LIKE '%.pdf%';

Regards

SillyGoose · September 2023

https://wordpress.org/plugins/update-urls/

Try this

Ympker · September 2023

This could also work: https://wordpress.org/plugins/better-search-replace/

SillyGoose · September 2023

@Ympker said:
This could also work: https://wordpress.org/plugins/better-search-replace/

That one never worked out for me.

alt_ · September 2023

UPDATE wp_posts SET guid = REPLACE(guid, 'domain.com', 'v2.domain.com') WHERE post_type = 'attachment' AND post_mime_type = 'application/pdf';

Ympker · September 2023

@SillyGoose said:

@Ympker said:
This could also work: https://wordpress.org/plugins/better-search-replace/

That one never worked out for me.

Hm, it worked for me in the past. Ofc, might also search/replace in PHPMyAdmin directly (without the need for any plugin)

Outdoor · September 2023

https://wordpress.org/plugins/update-urls/
https://wordpress.org/plugins/better-search-replace/

This 2 did not work, i need only to update pdf links, not all links at web site.

Every pdf document have different name.

Outdoor · September 2023

@alt_ said:
UPDATE wp_posts SET guid = REPLACE(guid, 'domain.com', 'v2.domain.com') WHERE post_type = 'attachment' AND post_mime_type = 'application/pdf';

I will try this

alilet · September 2023

Take backup
mysqldump -u root -p my_db > /var/www/databasebackup/dbbackup.sql

Find/Replace string in backup
sudo sed -i 's|domain.compdf|v2.domain.compdf|g' /var/www/databasebackup/dbbackup.sql

Restore database
mysql -u root -p my_db < /var/www/databasebackup/dbbackup.sql

emgh · September 2023

Just look up the table structure and query the DB. ChatGPT could do it all for you.

Keep a backup in case.

hiphiphip0 · September 2023

wp search-replace 'https://domain\.com/wp-content/uploads/(\d{4})/(\d{2})/(.+)\.pdf' 'https://v2.domain.com/wp-content/uploads/$1/$2/$3.pdf' --regex

Try to modify this.

Or simply add this to Nginx conf:

 location ~* \.pdf$ {
     proxy_pass https://v2.domain.com$request_uri;
 }

Or

http {
upstream file_servers {
server v2.domain.com;
server v3.domain.com;
# add more...
}

server {
    listen 80;
    server_name domain.com;

    location ~* \.pdf$ {
        proxy_pass http://file_servers$request_uri;
        proxy_next_upstream error timeout invalid_header http_404;
    }

    # ... 
}

}