It depends on what version of WordPress your sites run. If you are up to date, you shouldn’t have much of an issue. According to the official WordPress hosting guide, any version of MySQL version 5.0.15 or greater is supported for WordPress. You can give this article a read and see if there is anything … 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
thanks for your time and thanks to @czerspalace I started the query with double quotation and then separate it with a single quotation and after looking at the echo output I found that there’s no spaces between From and table name this is the correct way $pending_reservations = $wpdb->get_results(‘ SELECT booking_calendars.cal_name FROM ‘.$wpdb->prefix.’booking_calendars AS booking_calendars … 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
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
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
The sticky posts info is stored in the sticky_posts option in the options table. It’s stored as serialized array e.g. a:2:{i:0;i:1272;i:1;i:1995;} You can modify it via the Options API but there’s a way to bulk edit posts in the backend: 1. Select the Sticky view: 2. Select all sticky posts and apply the bulk Edit … Read more
Yes – absolutely. Simply enter the appropriate hostname and credentials in wp-config.php. Instead of the default localhost use the hostname provided by your database provider. Example: define( ‘DB_HOST’, ‘mysql.example.com:3307’ ); https://codex.wordpress.org/Editing_wp-config.php#Set_Database_Host