REPAIRING MYSQL DATABASES WITH PHPMYADMIN If your website behaves strangely like throwing unknown errors or is not able to save settings permanently then it is likely that your database has become corrupted. When this happens, you can try to repair database tables using one of the most popular database administration tools phpMyAdmin or adminer. To … Continue reading “How to Repair mySQL Database with phpmyadmin and adminer”
Blog
How to clear browser cache, history and cookies?
Why is clearing browser cache necessary? Browsers like Safari, Firefox or Chrome attempt to keep local copies of pages, images, and other content you’ve visited, so that it does not need to be downloaded again later. Under certain circumstances caching does not work as intended and the browser insists on showing outdated content. Depending on … Continue reading “How to clear browser cache, history and cookies?”
Change Language Collation of all mySQL Database Tables
If the language collation of your production and staging site database server is different you can use the MySQL query below to create a new query which allows you to change the language collation of all database tables at once. SELECT CONCAT(“ALTER TABLE “, TABLE_SCHEMA, ‘.’, TABLE_NAME,” COLLATE latin1_general_ci;”) AS ExecuteTheString FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=”DATABASE_NAME” AND … Continue reading “Change Language Collation of all mySQL Database Tables”
WP Staging has an Astounding Review-to-Install Ratio
I am doing a lot of work to please my users, no matter if they use the free version of WP Staging or the premium variant named WP Staging Pro. The main secret of the success of WP Staging is its simplicity but much more how I handle all the incoming support tickets. I do … Continue reading “WP Staging has an Astounding Review-to-Install Ratio”
MySQL Query – Delete all WooCommerce Bookings
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’;
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 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”