Restore old WordPress site

  • Resolved Stefan2902

    (@stefan2902)


    6 years ago

    Dear all,

    I have been running my own WordPress blog on RPI3, Nginx server until end of last year. I have created backups from both my mariadb database as well as the whole WordPress folder (located under /var/www/html).

    Now I would like to restore my blog because I would like to use it again. Having installed raspbian butcher and newer version of php and nginx I was wondering what would be the easiest way how to bring back my content? It is mainly about posts and the associated pictures / videos?

    Do you have any guidance on if I shall use import / backup / restore tools or better copy files from wp-content? And how to treat the database export? Any hint would be great.

    Stefan

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

    (@corrinarusso)

    6 years ago

    @stefan2902

    If you only want the content, you can use Tools –> Export –> to XML.

    You can also use a migration tool like All In One Migration plugin.
    – install AIOM on your old site
    – export
    – install a fresh instance of WordPress whereever
    – install AIOM on the new site
    – import the file you exported earlier

    Thread Starter Stefan2902

    (@stefan2902)

    6 years ago

    Thanks for the swift reply. Unfortunately I no longer have access to the old site. I only have the binaries (folder) as well as a MySQL export dump. The site is not available anymore and I somehow need to deal with that. Hence exports of old site is not possible anymore. Hence I am seeking for the least complex solution to import content (pictures / movies) and posts?

    corrinarusso

    (@corrinarusso)

    6 years ago

    @stefan2902

    What do you mean binaries ? binaries of what ?

    The content data is all in your database tables. Take a look at _posts and _postmeta.
    The settings for your old site are also in your database if you wanted them.
    You can still install a new instance of WordPress, then over-write the wp-content folder if you have that. You can use sql to extract your old posts, psuedocode :

        SELECT  * from posts 
      inner join postmeta ON 
            post_id = postmeta.id
    WHERE   post_status = 'publish'
    Thread Starter Stefan2902

    (@stefan2902)

    6 years ago

    Thanks again for the quick response. With binaries I meant all files underneath the /var/www/html/wordpress folder.

    So if I understand you right I should import the sql file to re-create the old database and it’s settings and afterwards copy over the wp-content folder right? Will check that tomorrow morning.

    corrinarusso

    (@corrinarusso)

    6 years ago

    @stefan2902

    Here is what I would do :
    – install XAMMP or MAMP on your machine
    – use phpMyAdmin to create a database called wp1
    – import your tables into the db
    – move the entire wordpress folder from your backup into your htdocs (www) folder
    – update the wp-config.php file to connect to this db
    – update the site_url and site_home values in the _options table to point to your localhost i.e http://localhost/oldsite
    – check the email address in the _users table
    – use Forgot Password http://localhost/oldsite?lostpassword
    – login and install All In One Migration plugin and export the site
    – install a new instance of wordPress under localhost in a different folder
    – install the All In One Migration plugin in the brand new instance of wordpress and import the file you just exported.
    Now you have a new instance set up with the old content.

    Thread Starter Stefan2902

    (@stefan2902)

    6 years ago

    I have followed your instructions so far and managed to use the old site. Now I have installed all in one migration tool but the export stops saying that size is beyond 1GB. Is there any way to increase size limits for export?

    Thread Starter Stefan2902

    (@stefan2902)

    6 years ago

    Fixed it now. Thanks for the support! Used older version of all in migration tool to import the backup.

    corrinarusso

    (@corrinarusso)

    6 years ago

    @stefan2902

    Haha. Yes, that’s the trick. 🙂

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

The topic ‘Restore old WordPress site’ is closed to new replies.