35% OFF EVERYTHING
WordPress 21st BIRTHDAY SALE
Buy Now

Custom Post Types Transfer

This topic contains 8 replies, has 2 voices, and was last updated by  Paolo 9 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • November 24, 2014 at 7:41 pm #22488

    almatesic
    Buyer
    Post count: 7

    I’m trying to transfer the custom post types from my development server to the production server. The database is transferred fine. Well at least it looks fine to me. But when I go look at my wordpress back end I do not see anything.

    Development Server
    https://db.tt/CR9g4lJS

    Production Server
    https://db.tt/T1w9FBFI

    What am I not doing right?

    November 24, 2014 at 7:44 pm #22489

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    the tool used to transfer the database is not transferring GD tables.

    Make sure to use a tool like this that will take the entire DB into consideration and not one taking only tables with wp_ prefix.

    I suggest this one: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

    Thx

    p.s. starting with the next release, this problem will never come up again, because to make GD multisite compatible we had to add the wp_ prefix to gd tables too.

    Thx

    November 24, 2014 at 8:01 pm #22491

    almatesic
    Buyer
    Post count: 7

    I have both databases with the same tables…
    https://db.tt/CfF1FsNi

    I exported the SQL from the dev site. Opened it and did a full find and replace with the new URL. Then I uploaded the SQL to the production server. All the other settings came in except that.

    November 24, 2014 at 8:05 pm #22492

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    what did you do the find and replace with? Notepad?

    If yes, that will break most of your options.

    Search Replace DB version allows you to carry out database wide search/replace actions that don’t damage PHP serialized strings or objects with a user friendly interface and experience.

    Thx

    November 24, 2014 at 8:07 pm #22493

    almatesic
    Buyer
    Post count: 7

    Dreamweaver. I have never had an issue with it in the past. And I’ve done a ton this way.

    I can try to re upload the database with the tool you provided me. Let me try it that way.

    November 24, 2014 at 8:10 pm #22494

    almatesic
    Buyer
    Post count: 7

    I just ran the tool on the live database and got this…
    https://db.tt/mwI38QR6

    November 24, 2014 at 8:15 pm #22496

    Paolo
    Site Admin
    Post count: 31206

    Looks like you are running it on a DB where it’s been already replaced (damage already done).

    All text editors (no matter how sofisticated), by doing a simple find and replace will break object and serialized strings.

    If you do it on a simple wordpress blog, it will result in all widgets removed from your widgets areas.

    With GD it will result in many more problems.

    You should run it on the original DB. (the one that works correctly on the development website)

    Thx

    November 24, 2014 at 8:18 pm #22497

    almatesic
    Buyer
    Post count: 7

    that tool did the trick. I’m surprise the way I always do it didn’t update it properly. Thank you for your help.

    November 24, 2014 at 9:03 pm #22500

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    you’re welcome, you prbably didn’t notice, but you were definitely losing widgets and other options in the past too.

    The only way to do a complete and clean find and replace is through a PHP script like this one.

    There is no way a text editor can do that.

    I’m glad we solved.

    Thx

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket