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”
Blog
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 Convert WordPress Staging Site to Production Site with WP Staging basic version If you like to do the migration automatically with WP Staging Pro read that article. This tutorial explains how to migrate manually your site by using WP Staging basic version. Read the instructions below very carefully and do not miss any … 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”
Serialized Data, What Does That Mean And Why is it so Important?
Note: This article is for people interested in programming. If you just like to use WP Staging you do not need to read or understand the article below. WordPress core and most of its plugins are storing data in the database in a special format, so called serialized data representation. That type is used for … Continue reading “Serialized Data, What Does That Mean And Why is it so Important?”