Due to the large volume of support requests, you may experience longer wait until a supporter handles your request. We apologize for the inconvenience this causes. We do not have any recurring unknown issues so we encourage you to please search the forum for other support topics that might be helpful and to review our documentation and look at our erratas page for known issues. A supporter will respond to you as soon as possible.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

You are not logged in. You can view support threads, but not post.
If you are already logged in, please refresh your browser.

This topic contains 2 replies, has 2 voices, and was last updated by  Mihai 7 years, 8 months ago.

Author Posts
Author Posts
March 11, 2010 at 7:03 am #16738

eSKape

Hi WPML
I've searched the documentation, but cannot find any answers to this:
How do I move an existing WordPress installation with WPML to another domain on another server the right way?
I tried just moving files and exporting/importing the database, but that won't cut it. Actually, the page linkage works just after changing siteurl and home records from wp_options but I think that is because WPML matches the url of translated pages with the language domain in icl_sitepress_settings in wp_options. My guess is, that when the next new page (with translation) is generated, it would fail.
So, long story short - How to move a WP site with WPML the right way?

March 11, 2010 at 5:43 pm #16740

eSKape

After some (read: a lot) trial and error (a lot of errors) I believe I got it covered now.
See my problems here: http://wpml.org/forums/topic.php?id=1161&replies=8#post-5399
Something like this:
- Backup old site database tables
(Export from myPhpAdmin, remember to zip the database)
- Backup old site files
- Change wp-config.php to match new site database
- Import database tables to new site database
- With myPhpAdmin change the following to new site info:
= wp_options: siteurl
= wp_options: home
= wp_options: upload_path
Do NOT change wp_options: icl_sitepress_settings !!!
It will break the languages!
Information on this would be appreciated 🙂
- With myPhpAdmin do a database search for the old domain
Everything except wp_options: icl_sitepress_settings should
basically be changed, but be careful.
All occurrences of a string in a table can be replaced
by another string like this:
Do an SQL command with myPhpAdmin:
UPDATE tablename SET column = replace(column, "string", "another_string");
You COULD do multiple columns at once, but take it easy, no rush...
Anyway, you COULD do it like this:
UPDATE tablename SET column = replace(column, "string", "another_string"),
column2 = replace(column2, "string2", "another_string2");
You need to replace in these tables:
= wp_icl_string_positions
- This got all you strings that you have translated with WPML and their locations
= wp_posts: All the guid-records
- Posts may have manual links in other pages or posts in post_content column.
I'd recommend changing these manually.
= wp_postmeta
- There may be some metadata for some of your uploads, with references to
the old domain
You may have other plugins and settings, that references the old domain.
You may be able to change these in the WordPress Administration, but you
can change it here as well.
- Lastly, upload all the files with the wp-config.php changed
to match the new site database
I hope this helps in the understanding of moving a WordPress installation with WPML.org plugin from one server and domain to another.
Best regards
Svend Koustrup / eSKape
KoustrupIT
hidden link
hidden link <- I'll put this here as well

March 12, 2010 at 4:50 pm #16741

Mihai
Forum moderator

Thanks for this eSKape . This is great stuff.

The topic ‘[Closed] How to move a WP site with WPML the right way’ is closed to new replies.