Export WordPress from one domain to another domain
When you import the WXR file to the WordPress install on the new domain, be sure to click the “Download attachments” checkbox that you are presented during the upload process.
When you import the WXR file to the WordPress install on the new domain, be sure to click the “Download attachments” checkbox that you are presented during the upload process.
Change your query to: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_ID = wp_posts.ID WHERE ( wp_postmeta.meta_key = ‘Color’ AND wp_postmeta.meta_value IS NOT NULL ); That way it only gets the data in wp_posts, but still filters based on your criteria.
This is an answer to your title cuz’ i couldnt understand the question in your explenation 😉 Sure… no need to even work hard. Here you can find an easy way to do exatly that with ready designs: feed2js.org Hope This helps, Sagive.
Suggestions for what you can try: Try to remove the empty columns, especially post_excerpt. Try another import plugin. Try another delimiter.
I’d dump part of the database and see how the posts/pages/ titles, date and other meta is arranged and compare it to WordPress’s DB structure. See http://codex.wordpress.org/Database_Description and http://codex.wordpress.org/Importing_Content for existing importers. Decide what you really need to import and what needs to be generated that is specific to WP. It’s not going to be … Read more
If you cannot install your own plugins you could set up a separate WordPress installation where you can do that and use the plugin HTML Import 2. From this site you can create a regular export file. You will not get all meta data (tags, categories etc.) though.
These plugins, by their description, appear to do what you want. Cache Images (by Matt Mullenweg—if I were you, I’d try this first) Add Linked Images To Gallery Hot Linked Image Cacher But looking at the support forums, it’s apparent that the plugins work for some and don’t for others (probably due to some incompatibilities). … Read more
Most likely “Search RegEx” triggered a filter/action that “Add Linked Images…” was attached to, which caused the import.
When you’re exporting from a localhost installation, the other installation cannot import images because it technically needs to be ‘online’ for the new installation to download the images off the older one. The easiest thing to do would be to migrate the old site to an online installation. You can read about how to move … Read more
I found the issue, thanks to @Toscho giving me the spark of an idea. We are using custom user roles and capabilities. It had something to do with the User Role Editor plugin. Deleted the custom role, and created a new one, reassigning all capabilities. Then updating all users to the newly created user role. … Read more