Name | Update Time |
Netflix | October 18, 2024 4:49 pm |
Disney+ | October 18, 2024 11:03 am |
Max | October 18, 2024 11:34 am |
ChatGPT 4 | October 18, 2024 2:27 pm |
Spotify | October 18, 2024 11:49 am |
Prime Video | October 18, 2024 5:17 pm |
Codecademy | October 18, 2024 5:08 pm |
Grammarly | October 16, 2024 2:31 pm |
Canva Pro | October 18, 2024 5:12 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
2024 Codecademy Premium Account Cookies
- October 18th, 2024
- 1465 Views
2024 Grammarly Premium Account Cookies
- October 16th, 2024
- 2530 Views
2024 ChatGPT 4 Premium Account Free Cookies
- October 18th, 2024
- 2695 Views
2024 Canva Pro Free Team Invite Link And Cookies
- October 18th, 2024
- 4681 Views
Perplexity AI Premium Cookies 2024
- April 17th, 2024
- 1564 Views
Email Marketing-What Is Email Marketing?
- October 24th, 2023
- 1044 Views
Content Marketing-What is Content Marketing
- October 24th, 2023
- 1322 Views
Social Media Marketing-Social Media Marketing (SMM)
- October 24th, 2023
- 1591 Views
Pay-Per-Click-What is PPC
- October 24th, 2023
- 1190 Views
Free Method To Get Canva Pro Without Paying
- September 9th, 2024
- 98 Views
Register a navigation menu in WordPress
- August 7th, 2024
- 98 Views
2024 HBOMax Premium Accounts
- October 18th, 2024
- 957 Views
WordPress template main file composition
- August 1st, 2024
- 92 Views
Method To Skip Verification On Nord Vpn
- September 11th, 2024
- 92 Views
Email Marketing-Boost your content through email
- August 12th, 2024
- 87 Views
WordPress-Use the get_footer() function to load and display footer content
- August 9th, 2024
- 81 Views
Recent Post
2024 Codecademy Premium Account Cookies
- October 18th, 2024
- 1465 Views
2024 Grammarly Premium Account Cookies
- October 16th, 2024
- 2530 Views
2024 ChatGPT 4 Premium Account Free Cookies
- October 18th, 2024
- 2695 Views
2024 Canva Pro Free Team Invite Link And Cookies
- October 18th, 2024
- 4681 Views
Perplexity AI Premium Cookies 2024
- April 17th, 2024
- 1564 Views
Email Marketing-What Is Email Marketing?
- October 24th, 2023
- 1044 Views
Content Marketing-What is Content Marketing
- October 24th, 2023
- 1322 Views
Social Media Marketing-Social Media Marketing (SMM)
- October 24th, 2023
- 1591 Views
Pay-Per-Click-What is PPC
- October 24th, 2023
- 1190 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.