phpmyadmin to copy posts from one WP site to another?

 

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 461 Times in 273 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
    271
    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 461 Times in 273 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
    227
    Thanked 241 Times in 172 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,538
    Thanks
    132
    Thanked 1,075 Times in 685 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
    271
    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
    205
    Thanks
    30
    Thanked 42 Times in 31 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
    87
    Thanked 38 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
    383
    Thanks
    8
    Thanked 139 Times in 101 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 Jr. VIP
    Join Date
    Nov 2012
    Location
    South Africa
    Age
    22
    Posts
    1,896
    Thanks
    3,816
    Thanked 2,763 Times in 1,229 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
    derago21.com
    Posts
    1,886
    Thanks
    2,388
    Thanked 949 Times in 380 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


Similar Threads

  1. Looking for seo blo/site posts/copy
    By PeaceLoveSubmission1 in forum Hire a Freelancer
    Replies: 5
    Last Post: 06-08-2013, 11:11 AM
  2. Replies: 25
    Last Post: 10-27-2012, 12: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