phpmyadmin to copy posts from one WP site to another?

 
Hostwinds

Results 1 to 11 of 11
phpmyadmin to copy posts from one site to another? So I have 2 WP sites ...
  1. #1
    Bostoncab's Avatar
    Bostoncab is offline Elite Member
    Join Date
    Dec 2009
    Location
    Boston,Ma.
    Age
    38
    Posts
    2,248
    Thanks
    1,833
    Thanked 463 Times in 274 Posts

    Default phpmyadmin to copy posts from one WP site to another?

    phpmyadmin to copy posts from one site to another?

    So I have 2 WP sites all set up on my server and I no longer own the domain. These are adult tube blog sites. I want to copy the posts from these now dead sites into another wordpress tube blog I am running on another domain in a different database.

    Is this possible through phpmyadmin?

    If so please explain how?

  2. #2
    TheeAriGrande is offline Regular Member
    Join Date
    Jul 2013
    Location
    Candlestick Park
    Posts
    270
    Thanks
    90
    Thanked 145 Times in 117 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Yes, it's possible. You have to export the old WordPress database into an sql file. Then import that sql file into the phpmyadmin of the new sites.

    This will export ALL the tables. If you just want to export the posts then you only have to export the post and the post meta tables.

    There's plenty of sites that have guides and visual aids. A quick search in google should bring up some good results.

  3. #3
    Bostoncab's Avatar
    Bostoncab is offline Elite Member
    Join Date
    Dec 2009
    Location
    Boston,Ma.
    Age
    38
    Posts
    2,248
    Thanks
    1,833
    Thanked 463 Times in 274 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Quote Originally Posted by TheeAriGrande View Post
    Yes, it's possible. You have to export the old WordPress database into an sql file. Then import that sql file into the phpmyadmin of the new sites.

    This will export ALL the tables. If you just want to export the posts then you only have to export the post and the post meta tables.

    There's plenty of sites that have guides and visual aids. A quick search in google should bring up some good results.
    know of one that is especially easy for a dummie?

  4. #4
    tnhomestead's Avatar
    tnhomestead is offline Sasquatch Lite
    Join Date
    Oct 2011
    Location
    Tenneessee USA
    Posts
    380
    Thanks
    228
    Thanked 243 Times in 173 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Be careful when you do it -- dont try to modify the data, its serialized. Here is a quick guide.
    http://www.siteground.com/tutorials/...e-transfer.htm

  5. #5
    verilix's Avatar
    verilix is offline Jr. VIP
    Join Date
    Sep 2009
    Age
    24
    Posts
    2,569
    Thanks
    132
    Thanked 1,089 Times in 692 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    It's as easy as selecting the two tables, then scrolling down and clicking export.

  6. #6
    TheeAriGrande is offline Regular Member
    Join Date
    Jul 2013
    Location
    Candlestick Park
    Posts
    270
    Thanks
    90
    Thanked 145 Times in 117 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Search for a guide from "web kreation" (I can't post urls yet). It takes you through all the steps needed. This guide migrates the whole site, not specifically posts. I'm not sure if it's safe to migrate only select tables as it could cause some relationship problems.

    I take no responsibility if anything happens to your sites. I'd recommend backing up everything before you attempt anything.

  7. #7
    UnSourCeR's Avatar
    UnSourCeR is offline Regular Member
    Join Date
    Aug 2011
    Posts
    208
    Thanks
    30
    Thanked 44 Times in 33 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    If you want to just clone/move a wordpress site WP Clone plugin is the way to go!

  8. #8
    mergethegreat is offline Jr. VIP
    Join Date
    Aug 2009
    Posts
    131
    Thanks
    89
    Thanked 40 Times in 17 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Use a plugin called duplicator.

  9. #9
    JustUs is offline Regular Member
    Join Date
    May 2012
    Posts
    410
    Thanks
    8
    Thanked 179 Times in 126 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Since you are speaking of using PHPMyAdmin that means that you still have access to the site. Just use the multi site export feature of Wordpress. It will download a small file to your computer. You then import the file into your new site, and Wordpress will get the files and set up the database.

  10. #10
    Treeofl1's Avatar
    Treeofl1 is offline Web Design
    Join Date
    Nov 2012
    Location
    South Africa
    Age
    22
    Posts
    2,279
    Thanks
    4,670
    Thanked 3,313 Times in 1,475 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    Quote Originally Posted by JustUs View Post
    Since you are speaking of using PHPMyAdmin that means that you still have access to the site. Just use the multi site export feature of Wordpress. It will download a small file to your computer. You then import the file into your new site, and Wordpress will get the files and set up the database.
    This^

    It's the easiest way if you have access to your wp-admin.

  11. #11
    derago21's Avatar
    derago21 is offline ★Xtreme Link Builder★
    Join Date
    Oct 2010
    Location
    Your Brain
    Posts
    1,967
    Thanks
    2,402
    Thanked 979 Times in 401 Posts

    Default Re: phpmyadmin to copy posts from one WP site to another?

    I really don't know, whether the above comments have helped you.
    But here is a tutorial which helped me to learn to do that

    Code:
    http://support.hostgator.com/articles/hosting-guide/website-transfers/how-to-transfer-your-wordpress-blog-from-one-host-to-another-host

Link Processor


BlackHatWorld Advertising

Similar Threads

  1. Looking for seo blo/site posts/copy
    By PeaceLoveSubmission1 in forum Hire a Freelancer
    Replies: 5
    Last Post: 06-08-2013, 12:11 PM
  2. Replies: 25
    Last Post: 10-27-2012, 01:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


 



BlackHatWorld on Twitter BlackHatWorld on FaceBook


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109