Use phpMyAdmin to replace WordPress blog content in batches

Source: Internet
Author: User
Tags wordpress blog
Previously, the blog Alliance has introduced how to achieve seamless transfer between two domain names. Today, the blog alliance will introduce how to implement batch content replacement from phpmyadmin. For ease of description, we take the specific domain name as an example-how to batch link all the content of show.blogunion.org to blogunion.org. First, a while ago, the blog Alliance has introduced how to achieve seamless transfer between two domain names. Today, the blog alliance will introduce how PhpmyadminContent can be replaced in batches.
For ease of description, we take the specific domain name as an example-how to batch link all the content of show.blogunion.org to blogunion.org.

Step 1: back up the original database and import the new database. all files uploaded under the original domain name will be uploaded again according to the original directory.

Step 2: Go to phpmyadmin and click search to search for the content you want to replace.In this article, search for show.blogunion.org. Then you will find that many tables in phpmyadmin involve show.blogunion.org.

Enter the content you want to search for in the search box.


The search results show the tables involved in the replacement.
Step 3: click a table and find the field where blogunion.org is to be replaced.
Step 4: go to the SQL interface and run the following MySQL statements: UPDATE 'umdposts' SET 'Guid '= REPLACE ('Guid', 'show .blogunion.org ', 'blogunion. org'); where umdposts is a table and guid is a field.




Step 5: replace other related content in batches. If the file directory is changed, you must modify the path of the file directory in batches.
Step 6: When you search for a replacement, the following screen will show you a complete success.




Note: This article only demonstrates replacing links in batches, and replacing other content with the same operation. If this article is helpful to you, you can use the button below to donate to the blog Alliance. five hairs are not too small, and fifty are not too many. thank you!


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.