WordPress.org

Ready to get started?Download WordPress

Forums

Pages Text (3 posts)

  1. Hardii
    Member
    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?

    -Hardii

  2. David Gard
    Member
    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
    Member
    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.

    -Hardii

Topic Closed

This topic has been closed to new replies.

About this Topic