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”
Blog
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?”
20 Free to Use WP Staging Assets For Blogs And Articles
WP Staging Creatives Often, we get requests by bloggers who like to write about WP Staging to tell their readers why WP Staging is one of the best plugins to create WordPress Staging Sites. We are also asked periodically if there are logo and images which can be used in blog posts and articles about … Continue reading “20 Free to Use WP Staging Assets For Blogs And Articles”
WP Staging Pro 2.2.0 – Latest Update News
This is the complete changelog for all modifications of WP Staging Pro 2.2.0 WP Staging Pro 2.2.0 Fix: Cloning a new site results in [undefined] Fix: Show all tables from the tables selection dialogue and use default selection for correct tables Fix: If clone has been created with an older WP Staging version its not possible … Continue reading “WP Staging Pro 2.2.0 – Latest Update News”