• Home
  • Cloud
    • General
    • SaaS
    • BPaaS
    • PaaS
    • IaaS
    • Other Internet Hosted Applications
      • WordPress
        • WooThemes Canvas
          • WooThemes Canvas CSS
  • About me
  • Why Badly Wired?
  • Contact

Badly Wired

Connecting WordPress via APIs, Plugins and other stuff - a technical notebook

You are here: Home / Tech Tips / Importing large WordPress Blog from one server to another

Importing large WordPress Blog from one server to another

19th February 2014 by Alan Leave a Comment

Fully Managed UK Hosting - Only £1+VAT till 1st Jan 2021 on Shared, Reseller and Dedicated Hosting! .... read more ....

I am writing this post as I have learned that moving a big blog from one server to another can be difficult.

As most movements I have are from a stand alone WordPress site to a Multi-Site, I find the export / import the easiest way, but it isn’t without issues.

Fully Managed UK Hosting - Only £1+VAT till 1st Jan 2021 on Shared, Reseller and Dedicated Hosting! .... read more ....

The Export/Import method is describe well  here on wpmudev here so I won’t repeat it.

If I’m just moving a WordPress single site to another host on the same domain, then the easiest way if to backup and restore, and if you have c-panel on your hosting this is really easy.  WordPress have some information on their codex here,   but it isn’t easy. Sometime you don’t have cpanel access or server access, so the import technique can be used by setting up an empty WordPress install on your new server.

Back to Export/Import method, this works fine, IF the blog / site isn’t too big. You start to run into trouble when the site is large, and especially if you want to import media, and the other host is slow, as you get timeouts.  Even where I have control over all my own server settings, moving 2gb of media from a GoDaddy site will result in failures.

The solution to this is DO NOT tick the import media box.

p.s. if you have difficulty importing the xml file WITHOUT media, and can’t get you PHP setting  sorted you can split the xml import file, and this tool does the job WordPress WXR File Splitter (RSS XML).

If you don’t import media, your site will still LOOK like it is OK as the post will all point to the urls on the remote server. Obviously that will become a problem when you turn the old site off.

But there is a great plugin ‘Image Teleporter‘  that literally brings onboard all the images and updates the links in your posts, even has a batch mode in case timeouts are an image, simple to use. Job done!

Well nearly. In a recent transfer, somehow (maybe from older versions of  WordPress, maybe cause it was on a windows host – don’t know)  that a good thousand images had special characters in the filenames, that broke WordPress Media Library and presented broken images.

The solution to this is a bit more tricky.

Step 1

Install the plugin ‘Media File Renamer‘  , another great little plugin, you can set your file name to your  image title.  I think the idea is really for SEO, but this way the filename get cleaned up and ‘unbroken’.

There is a batch mode that will change all filenames that don’t match titles.

Step 2

If however you have over 1,000 images that have empty titles and need titles for the plugin to work, that is a lot of typing to create a load of unique titles.

Step 3

However, a little bit of database manipulation and you can generate titles for all the missing ones. You may need to alter this code to suit your own requirements (always back p your database, and no liability accepted here). This code for instance will add a RANDOM title to all posts that have jpeg files and no existing title on multisite blog 134.

update `wp_134_posts`
set post_title = concat(
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97),
char(round(rand()*25)+97)
)
where
`post_title` = ''
and
post_type = 'attachment'
and
post_mime_tpe ='image/jpeg'
[Next] Find out where to host WordPress [Read the full article…]

Filed Under: Tech Tips, Wordpress  Tagged: export, import, plugins

About Alan

I'm Alan from Fullworks Digital Ltd, where I develop WordPress Plugins and support and manage WordPress websites.

My day job consists of solving clients' WordPress issues and developing new code and solutions.

I started as a professional programmer in 1979 and had been involved with the IT of business technology in virtually every area that exist.

Badlywired.com is my personal blog and my aide memoire of the many interesting facts that I come across. As I spend a lot of time gathering parts of solutions from the internet and assembling them into my own solutions, and also just learning how to do things, this blog is primarily my 'note book' and a way of giving something back to the online community that has helped me extensively.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Applications
  • Cloud
    • General
    • Google Cloud
    • IaaS
    • Other Internet Hosted Applications
      • Wordpress
        • WooThemes Canvas
        • WooThemes Canvas CSS
    • SaaS
  • Code snippets
  • Discounts
  • Genesis
  • Google Apps for Works
  • Linux
  • News
  • SEO
  • Server setup
  • Services
  • Tech Tips
  • Uncategorised
  • Useful Images
  • Useful Stuff
  • WordPress Hosting
  • WordPress Plugins

Tags

background jobs beadcrumbs bind brandings Cache canvas Centos chrome css fail2ban Find firefox Flash fraud genesis gocardless godaddy Google google maps hackers internet explorer javascript KashFlow Linus linux Magento mapquest maps microsoft mysql news nohup php plugin plugins queens diamond jubilee replace SED SEO skype Varnish Virtualmin Webmin woothemes Wordpress

 

Affiliate and Privacy Notices

This site is free to use, but hopes to cover some costs through affiliate income, some products and links are affiliates and may earn the site advertising income.

Some affiliates use Cookies to track if you purchase from them, this allows them to apportion revenue to us you will need to refer to their specific privacy notices as to how you are tracked.

This site is a participant in the Amazon EU Associates Programme, an affiliate advertising programme designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.co.uk.

  • Privacy Policy

Copyright © 2021 · Badly Wired