I don’t think there is a good reason to actually do this, but you can simply use what’s in your config to point to another host. Right from the codex page. define(‘DB_HOST’, ‘mysql.example.com:3307’);
First, you’ll need to set up a WordPress cron job, and take note of its shortcomings… Using the Codex example, this is a structure of how this could be done: add_action( ‘my_daily_event’, ‘do_this_daily’ ); add_action( ‘wp’, ‘my_activation’ ); function do_this_daily() { // 1) Use get_posts to retrieve your Post Type // 2) Iterate through the … Read more
Sounds like you got a recycled domain and/or your hosting configuration is not configured right. Also by running a traceroute you have multiple domains set for both http://www.kgstiles.com & http://www.kgstiles.com/pureplantessentials This is a pretty common scenario but can sometimes cause some domain issues. I wouldn’t rule you the possibility of some external source affecting your … Read more
Use wp_cron to run a job every hour. http://codex.wordpress.org/Function_Reference/wp_cron Use $wpdb->get_results to fetch data from your external table. Example: $q = “SELECT * FROM my_table”; $results = $wpdb->get_results($q, OBJECT); foreach ( $results as $result) { } Insert new CPT-posts using wp_insert_post() http://codex.wordpress.org/Function_Reference/wp_insert_post
You could just run DELETE FROM wp_terms WHERE slug LIKE “museum-%” on you MySQL server, but that would probably leave some orphan rows in wp_term_taxonomy and potentially in wp_term_relationships if you have used the terms. While being a bit more complicated I would recommend deleting them using the WordPress API. Something like this might work … Read more
It is OK. And you can access this table with standard way, throught wpdb To insert data to your table use this code: global $wpdb; $wpdb->insert( ‘exampleTable’, array( ‘column1’ => ‘value1’, ‘column2’ => 123 ), array( ‘%s’, ‘%d’ ) ); To breafly explain what this code mean. WordPress sanitizes values before inserting them into database … Read more
I was able to find the name of the database in word-press’s wp-config.php file under the and was able to create a back-up of the file using MSQL workbench and the tutorial found here http://community.discountasp.net/showthread.php?t=11972.
I accidentally stumbled into the answer today when I forgot to turn on my MAMP managed mysql server. At this juncture it pointed me to the critical difference. This answer is phrased for anyone running MAMP but potentially has broader applicability (certainly LAMP, WAMP, etc.); if you’re experiencing the same problem in an non-MAMP environment … Read more
You can run the the_content filters on your data. foreach ($results as $r) { echo apply_filters(‘the_content’,$r); } That should get you the same formatting as in your posts. http://codex.wordpress.org/Function_Reference/apply_filters
The plugin folder had not been pulled by SmartGit. After deleting the wordpress folder on my local host and pulling again from the git it worked.