While not directly answering the question, I would strongly recommend you use a DB management application. phpMyAdmin IMO is a nightmare to work with, and as you have discovered, very difficult to manage large files. If you are on a Mac Sequal Pro is a really amazing app. If you don’t have external access to … Read more
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 how I do it. You may want to reset and call it as a function in case you want to reuse. // Most Recent function nt_mostrecent( $count ) { $my_query = new WP_Query( array(showposts => $count, order => ‘DSC’, orderby => ‘date’)); while ($my_query->have_posts()) : $my_query->the_post(); $posts .= ‘<a href=”‘ . get_permalink() . … Read more
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
There’s an add_feed() function. You pass it a function via the second callback parameter. So something like this should work: add_action( ‘init’, ‘wpse102646_all_items_feed’ ); function wpse102646_all_items_feed() { add_feed( ‘allposts’, ‘wpse102646_get_all_items’ ); } function wpse102646_get_all_items() { $args = array( ‘numberposts’ => -1, ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ); $posts = get_posts( $args ); $feed = … Read more
I am working on redesigning a fairly high profile blog. I suggested the best way to do that, rather than mockups, is to just upload their wordpress export to a new WP install on domain. I periodically (twice a year or so) pull the database from our primary site and import into a dev site. … Read more
It’s not difficult. You need to transfer files to the new server. Create a blank database and keep it’s name, user_name (this user must have all privileges of this newly created database) and password. Edit config.php file on new server with the these new details. Read: WordPress Codex for transferring site
I’m doing the same thing for my themes. I’m currently using twenty fourteen as a base for my child theme. What I do, I create 2 folders, namely css and functions. Say for instance I putting custom code in the footer, I will create a footerstyle.css in my css folder and a footer-functions.php in my … Read more
You seem to be confusing different things. I am not sure what precisely you mean by “transfer” (monthly bandwidth? disk space?), but 10GB figure likely isn’t about memory (RAM). Error you are getting is about RAM. 100663296 bytes corresponds to just 100MB. That much is typically enough for average WP install to function, but might … Read more