Support » Fixing WordPress » Pages Text

  • Hardii


    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?


Viewing 2 replies - 1 through 2 (of 2 total)
  • David Gard


    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 ( and click Pages, then copy the text.



    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.


Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Pages Text’ is closed to new replies.