Export your tables using phpmyadmin interface. Just select those tables only that you want to export from the old database and import those tables in the new database or you can run the command(query) in mysql to copy one table create table newdbname.newtablename like olddbname.oldtablename; INSERT INTO newdbname.newtablename SELECT * FROM olddbname.oldtablename; Repeat the same … Read more
Menu by itself is a taxonomy in WP. It means that you can find all menus in wp_terms table, by running following query: SELECT * FROM wp_terms AS t LEFT JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id WHERE tt.taxonomy = ‘nav_menu’; Menu item is custom post type in WP. They are stored in wp_posts … Read more
WP_Query orderby and tax_query
Custom field data saved in the wp_postmeta table. Best way to access custom field is using wordpress built-in functions. for example: <?php $mykey_values = get_post_custom_values(‘my_key’); foreach ( $mykey_values as $key => $value ) { echo “$key => $value (‘my_key’)<br />”; } ?> 0 => First value (‘my_key’) 1 => Second value (‘my_key’) 2 => Third … Read more
new multisite, old db
Child parent relationship inside WP DB
I’m currently dealing with a site using W3TC plugin and that plugin seems to provide a custom database handler which actually caches queries to memcache. Give that a try. Sidenote: Just make sure, in case you are using multiple production servers, to use a shared memcache server and that you don’t cache those queries on … Read more
Store partial database to an archive database time to time
Add a check when the plugin is activated to see if the data(column/table) already exists in db or not ? If the data aldready exists then skip the db part and just mark the plugin as active.
Fortunately, this complicated database query is no longer needed. WordPress 4.1 added the ability to make complex nested meta queries which is exactly the thing I was trying to accomplish. Here is the Trac ticket with the feature: https://core.trac.wordpress.org/ticket/29642