How to export database correctly for local to online

What Options are you changing after upload to production server? I think after upload .sql file your website don’t want appear in browser? Check it: After import your local .sql file to production server, log in to production/phpmyadmin website, go to wp_options and check values: | option_id | option_name | option_value | —————————————— | id=1 … Read more

Moving 2 wordpress sites to one

I’d use the export tool but split the files using a tool like http://rangerpretzel.com/content/view/20/1/ You may need to check everything individually to make sure there’s no conflicts like same name categories, tags and usernames. Check posts, pages, comments, custom fields, terms, navigation menus and custom posts for potential conflicts. You may want to set these … Read more

Import from HubSpot COS into WordPress 4?

but still looking for some guidance / suggestions on moving the look & feel [theme] Content Management Systems like WordPress separate the content from the design. You have the content; you now need the design. So you need to look at the HTML and CSS at Hubspot and read http://codex.wordpress.org/Theme_Development to see how to convert … Read more

Get all post from table and put it in excel sheet

Here’s the SQL I used to create this view in phpMyAdmin. Since you cannot get the permalink URL out of the database we have to pull the GUID. This link does in fact get you to your post, since it uses the unique ID of the post. SELECT `post_name`, `guid` FROM `YOUR_TABLE` WHERE `post_date` >= … Read more