Pages Text

  • Hardii

    (@hardii)


    11 years, 8 months 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

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

    (@duck_boy)

    11 years, 8 months 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.

    Thread Starter Hardii

    (@hardii)

    11 years, 8 months 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

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