Ready to get started?Download WordPress


Pages Text (3 posts)

  1. Hardii
    Posted 2 years ago #

    Hello, i i've got a backup of my previous wordpress site, and the only thing i want from it , are the my custom pages texts.
    There were a lot of the texts which i wanna get again.
    Can anyone tell me where can i find those pages texts?


  2. David Gard
    Posted 2 years ago #

    Do you mean that you have a backup of the database, and that you want to get the text from these pages from database?

    And by custom pages, I assume you just mean all of the pages that you created?

    If so, run this SQL and save the results.

    SELECT ID, post_name, post_title, post_contect FROM wp_posts WHERE post_type = 'page' and post_status = 'publish';

    If you infact mean that you have a full working backup of you site, then you should just be able to log in to the admin of the site (http://yoursite.com/wp-admin/) and click Pages, then copy the text.

  3. Hardii
    Posted 2 years ago #

    ye that's what i mean, but when i tried to upload my mysql db to a newhost and domain it gives me an error.
    -- Table structure for table wp_commentmeta
    DROP TABLE IF EXISTS wp_commentmeta ;

    Η MySQL επέστρεψε το μήνυμα: Τεκμηρίωση
    #1046 - No database selected

    And i am not that good with mysql. If its easy for you, tell me what to do step by step if you know ofc. Thanks in advance.


Topic Closed

This topic has been closed to new replies.

About this Topic