I am not sure where you got that export code but I don’t see the PRIMARY KEY defined as it should be. Take a look at the code from Core that creates the table: 87 CREATE TABLE $wpdb->commentmeta ( 88 meta_id bigint(20) unsigned NOT NULL auto_increment, 89 comment_id bigint(20) unsigned NOT NULL default ‘0’, 90 … Read more
Create a new file names wp-config.php and paste all the code than enter your db credentials it will solve your wp-config issue. <?php /** * The base configurations of the WordPress. * * This file has the following configurations: MySQL settings, Table Prefix, * Secret Keys, WordPress Language, and ABSPATH. You can find more information … Read more
1) In order to check what kind of prefix used by current installantion you can goto wp-config.php in a root directory and find line with $table_prefix = ‘PREFIX_HERE’; variable 2) Backup the DB before making any action! 3) Additionally check if other tables with different prefixes/name_patters are not used by badly-written 3rd party plugins. They … Read more
The wp_options table holds a lot of information, whether you deem it important or not really depends on what plugins and information you have set up on your website and how important your website is to you. For example as you’ve noticed it can hold the information for your active plugins, if you activate an … Read more
This wouldn’t be caused by a change in the database. What the error refers to is this: SELECT SQL_CALC_FOUND_ROWS wp_posts.id FROM wp_posts WHERE 1 = 1 AND 0 GROUP BY wp_posts.id ORDER BY wp_postmeta.meta_value + 0 DESC, wp_posts.post_date DESC LIMIT 0, 10 Your code only includes data from the wp_posts table (second line above) but … Read more
In a nutshell your needs are completely unsupported by WP API. Taxonomies in WP are a grouping mechanism. Their primary purpose is to query set of objects, belonging to a group (term) or groups. There is no reverse operation to provide a set of objects and inquire which groups (terms) it belongs to. On top … Read more
I never personally tried this, but your images and posts reside in your {prefix}posts (wp_posts) table. I would also copy {prefix}postmeta (wp_postmeta) over. So copying over those table should do what you want. Keep in mind that this won’t copy your categories and tags (meta), and your comments (comments) they reside in other tables, you … Read more
Something important – when you create a new post the first thing WordPress does is an auto-save, so yes the first time the values should be empty. Perhaps that is what you are experiencing – I don’t see your full code, but I do see The plugin for the custom meta data is hooked in … Read more
I think you have two options to achieve what you are trying here. Option 1: Using custom post types This is the easiest route. WordPress does most of the work for you, while you can define your custom admin columns, add your post meta etc. WordPress will take of pagination and you can choose to … Read more
So basically you want to change the URL from subdomain to main domain in your DB so that it will work with your main Domain. What I do is I use search & replace DB script and in this I will enter my subdomain to search and to main domain to replace. You can download … Read more