How does WordPress bind a domain name
Step one: First resolve the DNS of your new domain name to your own On the server or space IP, the IP is bound to the new domain name.
Step 2: Then enter your website database management phpadmin, select the database of your website, and open the wp_options form, as shown below:
Step 3: Under the wp_options form, modify the siteurl file (the serial number is generally 1) to your new website domain name, and then modify the home file (the serial number ranges from about 30-40) to your new domain name. As shown in the figure below:
Step 4: In the SQL database command, enter the following code (note to change the domain name to your own, fill in the old domain name in front and fill in the last New domain name), click Execute.
UPDATE wp_options SET option_value = replace(option_value, ‘http://yshnet.com’, ‘http://ysh1314.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; /*修改站点url和主页地址*/UPDATE wp_posts SET post_content = replace(post_content, ‘http://yshnet.com’, ‘http://ysh1314.com’); /*修改文章中内部链接及附件的地址*/UPDATE wp_posts SET guid = replace(guid, ‘http://yshnet.com’, ‘http://ysh1314.com’); /*修改wordpress文章默认的永久链接*/UPDATE wp_comments SET comment_author_url = replace( comment_author_url, ‘http://yshnet.com’, ‘http://ysh1314.com’ ) ; /*修改作者的评论链接*/UPDATE wp_comments SET comment_content = replace( comment_content, ‘http://yshnet.com’, ‘http://ysh1314.com’ ) ; /*修改评论内的评论链接*/UPDATE wp_posts SET pinged = replace( pinged, ‘http://yshnet.com’, ‘http://ysh1314.com’ ) ; /*修改TrackBack里的链接*/
Step 5: Now the domain name of the website has basically been changed, but there will be a large number of internal links, anchor texts, pictures, etc. in your website that still use the old domain name. Now you need to use the following code, which can also be executed in the SQL database command. Pay attention to changing the domain name.
update wp_posts set post_content =replace(post_content,”yshnet.com”,”ysh1314.com”)
Notes
Notes: After the above five steps, the website is basically restored to the website of the new domain name, but there are some details, such as the website For maps, you can add relevant fixed links yourself. There are not many of them. You can just modify them manually. This method is based on my own website database interface. Different operators may have different database backends, but the relevant files and functions are all available. Webmasters can effectively choose to adopt them for reference.
For more WordPress technical articles, please visit the WordPress Tutorial column!
The above is the detailed content of How to bind a domain name to WordPress?. For more information, please follow other related articles on the PHP Chinese website!

Recently, we showed you how to create a personalized experience for users by allowing users to save their favorite posts in a personalized library. You can take personalized results to another level by using their names in some places (i.e., welcome screens). Fortunately, WordPress makes it very easy to get information about logged in users. In this article, we will show you how to retrieve information related to the currently logged in user. We will use the get_currentuserinfo(); function. This can be used anywhere in the theme (header, footer, sidebar, page template, etc.). In order for it to work, the user must be logged in. So we need to use

Do you want to know how to display child categories on the parent category archive page? When you customize a classification archive page, you may need to do this to make it more useful to your visitors. In this article, we will show you how to easily display child categories on the parent category archive page. Why do subcategories appear on parent category archive page? By displaying all child categories on the parent category archive page, you can make them less generic and more useful to visitors. For example, if you run a WordPress blog about books and have a taxonomy called "Theme", you can add sub-taxonomy such as "novel", "non-fiction" so that your readers can

One of our users asked other websites how to display the number of queries and page loading time in the footer. You often see this in the footer of your website, and it may display something like: "64 queries in 1.248 seconds". In this article, we will show you how to display the number of queries and page loading time in WordPress. Just paste the following code anywhere you like in the theme file (e.g. footer.php). queriesin

In the past, we have shared how to use the PostExpirator plugin to expire posts in WordPress. Well, when creating the activity list website, we found this plugin to be very useful. We can easily delete expired activity lists. Secondly, thanks to this plugin, it is also very easy to sort posts by post expiration date. In this article, we will show you how to sort posts by post expiration date in WordPress. Updated code to reflect changes in the plugin to change the custom field name. Thanks Tajim for letting us know in the comments. In our specific project, we use events as custom post types. Now

Do you want to move your blog from WordPress.com to WordPress.org? Many beginners start with WordPress.com but quickly realize their limitations and want to switch to the self-hosted WordPress.org platform. In this step-by-step guide, we will show you how to properly move your blog from WordPress.com to WordPress.org. Why migrate from WordPress.com to WordPress.org? WordPress.com allows anyone to create an account

Are you looking for ways to automate your WordPress website and social media accounts? With automation, you will be able to automatically share your WordPress blog posts or updates on Facebook, Twitter, LinkedIn, Instagram and more. In this article, we will show you how to easily automate WordPress and social media using IFTTT, Zapier, and Uncanny Automator. Why Automate WordPress and Social Media? Automate your WordPre

Just a few days ago, one of our users reported an unusual problem. The problem is that he reaches the limit of custom menu items. Any content he saves after reaching the menu item limit will not be saved at all. We've never heard of this issue, so we decided to give it a try on our local installation. More than 200 menu items were created and saved. The effect is very good. Move 100 items to the drop-down list and save them very well. Then we knew it had to do with the server. After further research, it seems that many others have encountered the same problem. After digging deeper, we found a trac ticket ( #14134 ) that highlighted this issue. Read very

Do you need to add custom metafields to custom taxonomy in WordPress? Custom taxonomy allows you to organize content besides categories and tags. Sometimes it is useful to add other fields to describe them. In this article, we will show you how to add other metafields to the taxonomy they create. When should custom metafields be added to custom taxonomy? When you create new content on your WordPress site, you can organize it using two default taxonomy (category and tag). Some websites benefit from the use of custom taxonomy. These allow you to sort content in other ways. For example,


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Mac version
God-level code editing software (SublimeText3)