Trying to script steps to move blog from 1.2 in one domain to 1.5 on another

  • I need some help trying to come up with a list of steps necessary to move my blog, currently using 1.2 on one domain, to a different host and domain.

    1) export database
    2) using text editor, convert hardcoded image links in the posts referring to the old domain to their equivalent URL in the new.
    3) install 1.5 on new server
    4) install all the anti-spam, comment enhancements, etc. on new empty blog
    5) import database?

    The tricky parts would be self-referential stuff, like if I mentioned a post within a post or comment. I could probably find those pretty in MySQL using a

    SELECT * FROM wp_posts WHERE
    post_content LIKE (‘%https://www.olddomain.com%’)
    AND post_content RLIKE ‘[[:<:]]https://www.olddomain.com[[:>:]]’;

    easily since they didn’t happen so often and GREP them to what they need to be.

    I’m concerned about “sins of omission” in the steps above. What am I missing? Are the table names the same between 1.2 and 1.5?

    It’d be nice to nail down the “recipe” here before I try cooking it.

Viewing 8 replies - 1 through 8 (of 8 total)

  • 1 & 2 are fine
    3 – Import sql and recreate the blog including plugins
    4 – Upgrade

    Thread Starter aaron1728

    (@aaron1728)

    Well, the new blog hasn’t been created. Are you suggesting I should create a 1.2 blog on the new domain and then import and then upgrade?

    Moderator James Huff

    (@macmanx)

    Yes, it is highly recommended that you move your v1.2 blog first.
    https://www.tamba2.org.uk/wordpress/move/

    Then, upgrade to v1.5.
    https://www.tamba2.org.uk/wordpress/upgrade/

    The reason why is simple. THere were some fundamental changes to some of the tables from 1.2 to 1.5…. If you simply import your 1.2 data into a 1.5database, some of the data may become borked. But if you take your 1.2 data import into a 1.2 data, make sure things still work as they used to, then upgrade, any changes to the data thats needed as part of the upgrade will be done correctly.

    Tg

    Thread Starter aaron1728

    (@aaron1728)

    Still trying to get an idea how to convert wp_posts

    Hey look at my old post

    to the new blog equivalent

    Hey look at my old post

    I want to get rid of the wordpress subdirectory for easier & shorter URLs.

    Moderator James Huff

    (@macmanx)

    ?! You don’t have to convert wp_posts. The upgrade script does it for you.

    Move your v1.2 blog first.
    https://www.tamba2.org.uk/wordpress/move/

    Then, upgrade to v1.5.
    https://www.tamba2.org.uk/wordpress/upgrade/

    Thread Starter aaron1728

    (@aaron1728)

    I would still have to convert the wp_posts to refer to the new directories for my images I planned to have. Because of the number of images, it was necessary for me to break up my images into multiple directories, or the server would go REALLY slow when I opened it for FTP.

    I always used hard-coded URLs for my images before and would assume that by copying the images to the desired directories and then GREPping the wp_posts BEFORE the move, the rest would go as you suggest.

    May I use relative URLs <img src=”/images/05Q1/this.jpg”> or should I use full URLs <img src=”https://www.newblog.com/images/05Q1/this.jpg”&gt; ?

    Relative will work. I recently moved acopy from my main server to my local mchine, changed the option in the DB backupfiles and restored locally, and my images are OK (as long as the struct is the same, it shouold be OK for relative.)

    Tg

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Trying to script steps to move blog from 1.2 in one domain to 1.5 on another’ is closed to new replies.