Export SQL query based on custom field?

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.

Importing a database from a custom built CMS to WordPress

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

How to export a WordPress blog with no export function?

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.

What is the plugin to import image from URL?

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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)