If you need to delete all WooCommerce booking with the custom post type wc_booking you can use the MySQL query below: DELETE FROM wpstg4_postmeta WHERE post_id IN ( SELECT ID FROM wpstg4_posts WHERE post_type = ‘wc_booking’ ); DELETE FROM wpstg4_posts WHERE post_type = ‘wc_booking’;
Blog
MySQL Query Delete all WooCommerce Orders
Use this MySQL query to delete all woocommerce order at once from the MySQL command line. This can be useful if you want to delete all orders on your staging site and then to import all orders again from the live site to make the staging site up to date before pushing it to the … Continue reading “MySQL Query Delete all WooCommerce Orders”
How to Fix Error: Could not save Password Reset Key to Database
Are you trying to login to your WordPress website but it failed? Do you try to reset the password and you get the error ‘Could not save Password Reset Key to Database’? This simply indicates that there is not enough free space left on your hosting account and WordPress is unable to write new login information … Continue reading “How to Fix Error: Could not save Password Reset Key to Database”
How to Change WordPress Table Prefix of mySQL Database
If you like to change the WordPress table prefix of the database on an existing WordPress website you can use the following SQL query: SET @database = “database_name”; SET @old_prefix = “old_prefix_”; SET @new_prefix = “new_prefix_”; SELECT concat( “RENAME TABLE “, TABLE_NAME, ” TO “, replace(TABLE_NAME, @old_prefix, @new_prefix), ‘;’ ) AS “SQL” FROM information_schema.TABLES WHERE … Continue reading “How to Change WordPress Table Prefix of mySQL Database”
Migrate WordPress Staging Site to Production Site
How to Push WordPress Staging Site to Production Site The tutorial below explains how to migrate your site by using WP Staging Free version. Read the instructions below very carefully and do not miss any step! If you want to read the Migration instructions for WP Staging Pro instead please read this article. The video … Continue reading “Migrate WordPress Staging Site to Production Site”
Revolution Slider X Theme Record not found
Did you install the X Theme by theme.co and got the message “Record not found” after installing the demo content or activating the slider revolution plugin? This is caused by a bug in the X Theme WordPress theme which you can resolve very easily. The reason for that issue is that X Theme expects at least … Continue reading “Revolution Slider X Theme Record not found”
How to Create and Add Admin User With MySQL in WordPress
Sometimes it happens that you lock ourselves out of the WordPress admin dashboard because you either made changes in the database or the admin account was deleted due to an accident or technical issue. To fix that we need to create and add new admin account directly in the database by using the MySQL syntax. … Continue reading “How to Create and Add Admin User With MySQL in WordPress”
Release of WP Staging Pro 2.4.5
Today, we released WP Staging Pro 2.4.5 with a lot of new useful features and important bug fixes. That version also contains some preparations for the upcoming version which allows cloning of WordPress multisites. For instance WP Staging Pro 2.4.5 allows you to define the maximum file size to copy. From now on you can … Continue reading “Release of WP Staging Pro 2.4.5”
Where Are WooCommerce Products Stored In The WordPress Database?
Sometimes you add new WooCommerce products on your staging site and just want to add those new products to the live site without affecting other data like orders and transactions. Therefore you need to make sure to copy only the relevant tables which contain the WooCommerce products data. Products are located mainly in 2 tables: … Continue reading “Where Are WooCommerce Products Stored In The WordPress Database?”
WP Staging 2.2.4 New Features
WP Staging 2.2.4 brings a lot of new features, fixes and improvements to make the creation of WordPress staging and test sites more reliable and easier than ever! Our biggest improvement is the support for search & replace of serialized data when a staging site is created. The pro version already supports that powerful feature … Continue reading “WP Staging 2.2.4 New Features”