Even after configuring the permanent domain name in WordPress, the database might still contain references to the temporary domain name. These references may still be in menu items, links and paths to images.
If you do not feel comfortable in making the changes listed below, then please ask Print Science to perform the work on your behalf.
¶ WordPress plugins
Here are 2 free-of-charge plugins that provide pages in the WordPress admin pages to make the domain name change:
¶ SQL query operating directly on the database
The pattern for the SQL queries to run are shown below.
UPDATE wp_posts SET guid = replace(guid, 'https://temporary.printsafe.net','https://permanent.com'); UPDATE wp_posts SET post_content = replace(post_content, 'https://temporary.printsafe.net', 'https://permanent.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://temporary.printsafe.net', 'https://permanent.com');
You must replace the domain names in the pattern above with your actual temporary and permanent domain names.
Here are the steps to take to run the queries directly in your database:
- Using text editor, prepare query text by replacing the domain names in the pattern above with your actual temporary and permanent domain names
- Login to your cPanel
- Select the phpMyAdmin tool
- Select the "SQL" tab at the top
- Paste the query text into window
- Click button "Go" at bottom right
An example of the SQL tab in the phpMyAdmin tool is shown below:
