Name | Update Time |
Netflix | September 18, 2024 9:50 am |
Disney+ | September 18, 2024 10:03 am |
Max | September 18, 2024 2:46 pm |
ChatGPT 4 | September 14, 2024 2:26 pm |
Spotify | September 18, 2024 2:50 pm |
Prime Video | September 18, 2024 3:00 pm |
Codecademy | September 18, 2024 2:54 pm |
Grammarly | September 14, 2024 4:45 pm |
Canva Pro | September 18, 2024 4:38 pm |
Udemy Premium Cookies | September 2, 2024 2:53 pm |
The general modification method is to click and modify one database table at a time, but this method is too inefficient. If you encounter a large number of never-path addresses in the article, the workload is even greater. At this time, we can implement batch modification by executing the sql statement in phpmyadmin. (If you don’t understand the database, you can first learn the introductory knowledge of website database.)
The operation method is very simple. You only need to open the database management phpmyadmin interface of the website space, find the sql button, and enter the following statement:
WordPress batch change domain name sql operation statement
The following are several commonly used sql statements, which can be used according to your needs.
Modify the statement in the configuration table:
UPDATE wp_options SET option_value = replace( option_value, ‘old domain’, ‘new domain’);
Modify the statement of the absolute address in the article:
UPDATE wp_options SET option_value = replace( option_value, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET post_title = replace( post_title, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET post_content = replace( post_content, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET guid = replace( guid, ‘old domain name address’, ‘new domain name address’);
UPDATE wp_postmeta SET meta_value = replace( meta_value, ‘old domain’, ‘new domain’);
UPDATE wp_termmeta SET meta_value = replace( meta_value, ‘Old domain’, ‘New domain’);
Modify the statement in the comment:
UPDATE wp_comments SET comment_content = replace(comment_content, ‘Old domain’, ‘New domain’);
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, ‘Old domain’, ‘New domain’);
Search
Popular on Blogar
Email Marketing-What Is Email Marketing?
- October 24th, 2023
- 941 Views
2024 Codecademy Premium Account Cookies
- September 18th, 2024
- 1254 Views
2024 Grammarly Premium Account Cookies
- September 14th, 2024
- 2198 Views
2024 ChatGPT 4 Premium Account Free Cookies
- September 14th, 2024
- 2164 Views
2024 Canva Pro Free Team Invite Link And Cookies
- September 18th, 2024
- 3724 Views
Perplexity AI Premium Cookies 2024
- April 17th, 2024
- 1249 Views
Content Marketing-What is Content Marketing
- October 24th, 2023
- 1229 Views
Social Media Marketing-Social Media Marketing (SMM)
- October 24th, 2023
- 1468 Views
Pay-Per-Click-What is PPC
- October 24th, 2023
- 1098 Views
What to do if the WordPress blog changes the site address (URL) and cannot log in?
- July 12th, 2024
- 96 Views
2024 Spotify Premium Account Cookies
- September 18th, 2024
- 912 Views
How to Use ChatGPT to Build a Website
- July 19th, 2024
- 89 Views
How to Change Your Domain Name on WordPress
- July 18th, 2024
- 86 Views
WordPress batch change domain name sql operation statement
- July 12th, 2024
- 85 Views
How to correctly set robots.txt on WordPress website
- July 22nd, 2024
- 83 Views
Recent Post
2024 Codecademy Premium Account Cookies
- September 18th, 2024
- 1254 Views
2024 Grammarly Premium Account Cookies
- September 14th, 2024
- 2198 Views
2024 ChatGPT 4 Premium Account Free Cookies
- September 14th, 2024
- 2164 Views
2024 Canva Pro Free Team Invite Link And Cookies
- September 18th, 2024
- 3724 Views
Perplexity AI Premium Cookies 2024
- April 17th, 2024
- 1249 Views
Email Marketing-What Is Email Marketing?
- October 24th, 2023
- 941 Views
Content Marketing-What is Content Marketing
- October 24th, 2023
- 1229 Views
Social Media Marketing-Social Media Marketing (SMM)
- October 24th, 2023
- 1468 Views
Pay-Per-Click-What is PPC
- October 24th, 2023
- 1098 Views
restore an overwritten WhatsApp backup
- September 18th, 2024
- 4 Views
- Howo Tractor Truck
- Howo Tipper/Dump Truck
- Howo Cargo Truck
- Howo Concrete Mixer Truck
- Howo Special Truck
- Howo Light Truck
- Shacman Tractor Truck
- Shacman Tipper/Dump Truck
- Shacman Cargo Truck
- Shacman Concrete Mixer Truck
- LGMG Mining Trucks
- XCMG Wheel Loader
- XCMG Excavator
- XCMG Crane
- XCMG Asphalt Pavers
- XCMG Road Roller
- Shantui Bulldozer
Copyright © 2024 BBBBF All Rights Reserved.