How to use to CHANGE DOMAIN name only

Hey,

i think the best way todo this is using the tab “Replace Domain/Url”. Here you have two input fields. In the first field you should see the development domain “http:\\clientname.net.temp.mydevhost.com\” the second is empty, here you past the replacement like “http:\\clientname.net\”.

Note: at the tab “Replace Domain/Url” nothing will replaced on the live database you can only download a sql with the replacements.

In your case you should use the “change table Prefix option”. After run the replacement you’ll get the sql file, import this in your database and switch the table-prefix in your wp-config.php

See here: https://cloud.githubusercontent.com/assets/809219/14198647/dc0afb48-f7dc-11e5-9821-a80b66c11817.png

—

Hey, please give me a feedback if had worked or not and vote for the Plugin or write about it in the Internet ??

Hello and thanks.

I do not have that option / tab, at present. Are you saying that feature is part of your “Search & Replace” plugin?

Will this approach also update wp-config.php or is that a manual effort?

Moreover, will this approach take care of WooCommerce? I am not familiar with how they store references to product images.

Hi, i’m sure the tab is a part of our plugin. if don’t have any tabs please check for an update or take care that you have the right plugin.

if you go the way i’ve described you have to change the table prefix at the wp-config.php and the domain will well replaced overall at the exported SQL-File.

Do the following steps:
1. make a backup of your database! (use the first tab or a plugin like backwpup)
2. run the described search & replace
3. change the table prefix at the wp-config.php
4. use the import tab to import the sql-file with the replacements

this will work.

If you need Professionell help feel free to write a mail to [email protected] and ask for a offer and reference this support ticket ??

Thank you, again, for your kind insight.

I’ll think I’ll first give it a go, by:

1. Backing up all files (wwwroot) – using Hosting Panel
2. Backing up the WP DB – also using Hosting Panel
3. Manually edit the WP-CONFIG.PHP file
4. Checking my .HTACCESS file is in good standing
5. Use phpMyAdmin tool to peruse the various tables and manually swap the aforementioned URLs. This tool is also available on my Hosting Panel

As a developer, I consider it much more valuable to understand what’s under-the-covers, prior to trusting any plugin .. whether it be yours, or any other listed in articles such as this.

Rene, before concluding this support ticket, what does “Choose dry run or download SQL file” accomplish?

I am hopeful that it will make your plugin ONLY report findings versus commit them. If so, I’d be interested in trying it out, to see what your plugin finds versus what I manually discover on my own.

Hey dry run do a real search & Replace but nothing will change on the database its only a trial and you can review it. Its all fine you can run a search & replace direct to the database or generate a sql for download.

Hallo und danke, Rene.

If I understood correctly, “Dry Run” will do the full search and report .. but not make any changes. Ist das wahr?

In regard to your 2nd point, this plugin is optionally able to replace *directly* to the database .. versus generating a SQL update script? Assuming this to be true, that would be precisely what I desire to do.

Please confirm!

If all is truth, I will do a DRY RUN first .. and thereafter do the Direct-to-Database update.

Rene –

It seems the DRY RUN option is not available for the REPLACE DOMAIN/URL tab. It’s only on the SEARCH & REPLACE tab.

What is the difference between the two tabs, in regard to my intended purpose?

Danke!

Hallo ??

The difference between this two tab are the Replace Domain URL never will do changes directly to the database. Here you get only a SQL-Download. So we try to prevent the users for self destroy on domain replacements! A head the only job of this tab is find and replace domains. You can use this to move or migrate a WordPress.

Alles klar soweit?

So far, I have not executed! I am grateful that you’re responsive on this weekend evening (2330 CEST)

A few points for you:
(1) After doing a backup, the button to download failed to do anything .. but disappeared after clicking. Where is the backup physically stored on the server? I’ll fetch it via FileZilla.

(2) The Search & Replace (dry run) located MANY instances. The report ran off the lower part of my Chrome browser and, despite the vertical scrollbar, it was still impossible to see the last few lines. Moreover, attempting to select-all unfortunately also included data from behind the non-modal pop-up. I merely wanted to keep a copy handy, for my own review.

Aside from that, it looks like it’s finding accurate data. My only remaining concern is that I noticed in the DRY RUN results the following changed values (other than my replacement text):

row	457	column	option_value	Old value:	a:1:{i:0;a:1:{i:0;s:35:"mydomain.com.temp.work.com/";}}	New value:	a:1:{i:0;a:1:{i:0;s:18:"mydomain.com/";}}

What is the value “S” and why would it change?

Vielen Dank, wieder, für Ihre freundliche Unterstützung!

hey i want to see you happy and want work hard for your 5 star rating ??

At first check my answer on this other support ticket https://www.ads-software.com/support/topic/can-backup-be-recovered?replies=3

2. can you tell me how big is your database? Sry we have actually trouble with big data ?? See here https://github.com/inpsyde/search-and-replace/issues/48

With the value “s” you mean this a:1:{i:0;a:1:{i:0;s:35:”my… ?

Here you see serialized data. This means the strln.

Ich hoffe es hilft weiter ??

I promise to choose “5-stars”, once we’re done here!

(1) OK – plugin’s backup is not stored locally. That’s good and preferred, actually. Not sure why it did not download .. but no worry, as I took a backup using my Hosting Panel services.

(2) My Hosting Panel says the mySQL db is 5968 KB. It’s a small website, with a handful of pages and posts. The largest table size is wp_postmeta with a mere 4,000 records. The second largest record count is 600 in the wp_options table. What do you consider “large” ?

(3) Hence, it’s of no concern that “S” (serialization) info is changing?

Ja, es ist eine gro?e Hilfe! Stand by please!!

Hmm. The Search & Replace feature seems to be confused – it throws this error:

Errors:
Your search contains your current site url.
Replacing your site url will most likely cause your site to break.
If you want to change the URL (and you know what you doing), please use the export function and make sure you backup your database before reimporting the changed SQL.

Is this triggered due to the fact that the search-for and replacement URLs are similar?

http:\\clientname.net.temp.mydevhost.com\
to
http:\\clientname.net\

I do not want to export / import, if I can avoid it. Just not comfortable proceeding in that manner.

Or, perhaps, this is due to the SETTINGS > GENERAL site values needing to FIRST be changed?

/wp-admin/options-general.php

• WordPress Address
• Site Address

While awaiting your feedback, I changed the two aforementioned General values and will continue to re-try your plug-in thereafter.

Sadly, this plugin failed to assist me, per my last feedback.

I did, however, use the “Dry Run” report as a reference, and swept the WPDB using phpMyAdmin.

For example, I used the following SQL command to update the list of WP tables below:

UPDATE wp_comments
SET comment_author_email = REPLACE(comment_author_email, 'clientname.net.temp.mydevhost.com', 'clientname.net')
WHERE comment_author_email LIKE '%clientname.net.temp.mydevhost.com%'

Tables : columns manually updated:

• wp_comments : comment_author_email
• wp_layerslider : data
• wp_options : option_value
• wp_postmeta : meta_value
• wp_posts : post_content
• wp_posts : guid

I am dismayed that, after your kind assistance and my own efforts, the plug-in was still having issues. I am hopeful that my feedback here will allow you to enhance the plug-in to work for people in my scenario.

Guten Morgen,

i’ve take a look at your last responses and test a run with a invert pattern.

Search for: https://www.playground.wp
Replace with: https://www.playground.wp.mydevhost.com\
Change database prefix: checked
New prefix: play_temp_mydevhost_

For a screen look here and here.

After i fixed some at the current master it works fine. You can download my test-db.

Here you can see the current changes.