WordPress.org

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

2. duck__boy
   Member
   Posted 10 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.

3. Hardii
   Member
   Posted 10 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

Reply

You must log in to post.