Database - Read For Learn

Moving database with phpMyAdmin

I would do this so. But this is probably not the most efficient way accomplishing this task. There are several plugins out there, that may automate this. If anyone knows one, that is good, I would like to hear about it. Plugins that look promising: http://wordpress.org/extend/plugins/xcloner-backup-and-restore/ http://wordpress.org/extend/plugins/duplicator/ http://wordpress.org/extend/plugins/wp-migrate-db/ Find more at: http://wordpress.org/extend/plugins/tags/backup

How best to inject ads between posts in the loop?

Probably just add a counter, show ad on multiples of 6. Something like $count = 0; $adEvery = 6; if (have_posts()) : while (have_posts()) : the_post(); // Individual Post $count++; if ($count%$adEvery == 0) { // your ad } endwhile; else : // No Posts Found endif;

Dynamic data in `wp_register_script` needed

You are looking for the wp_localize_script() function. This function allows you to add data from server to your javascript. However, this will not change the content of jsfile.js. Instead, it will add some global variable in your theme’s footer.Changing the content of a JS file before outputting it to the browser is an advanced technique, … Read more

Is altering a default WordPress database table update safe?

dbDelta is squirrelly. Some things it will alter, others it will not. For example, and if I remember correctly, you can add indexes to tables but not change those indexes or delete them. I honestly don’t know if it will remove table columns. (My guess it that it won’t but I may test that later.) … Read more

Extending the database

I’m not sure why you’re getting a 1. Your code says that you should not. However, it seems that what you’re doing is unnecessary and generally ill-advised. Modifying existing tables is usually not needed. The wp_comments table contains a comment_parent and user_id column. So if I reply to a comment, it’s immediate parent ID is … Read more

query to create woocommerce products from images

I’d agree that doing this in SQL would be a lot more to learn than PHP. With WordPress functions you can run a query on all the images ( WP_Query ) and then loop through the results and use the info from the images to create a new post using [wp_insert_post()][2]. Finally you can update … Read more

How to build a movie database with wordpress?

I’d point you to the much-cited Justin Tadlock “Using custom taxonomies to create a movie database” as a good place to start. His example is Popcritic. The saving favorites would probably require a different plugin, but such is the nature of WordPress.

Is deleting orphaned wp_options entries safe?

I have a wordpress site with some serious wp_options table bloating. This is causing slow page loads and memory bloat. After investigation, there appears to be thousands of orphaned entries. If you know for a fact these options are for plugins that are no longer in use, then yes it’s safe to delete them. If … Read more

how to transfer wordpress sql/database from local to live

I find the export tools very slow and not so reliable. If imporitng fails you probably have a timeout with your server or your dump file is too big. Here’s the way I do it, and it’s much faster: extract a fresh copy of wordpress code in production replace the wp-content folder with the one … Read more

storing database in version control

This is more a git question than a WordPress one IMHO, but what you need to do is write a bash script and associate with a git hook that does what you want.

+ More