Sometimes, it might be necessary to repair a MySQL database table. This can be the case if your WordPress site acts weirdly or slowly. So, for instance, when you notice that modified settings in your WordPress dashboard are not permanently saved, it could indicate a corrupted database table. Another indicator for a corrupted MySQL table … Continue reading “phpMyAdmin Repair and Optimize Database Tables Tutorial”
Blog
Linux & Docker Commands Reference & Troubleshooting
We’ve published these commands for our developers for reference purposes. They are publicly visible as it might be helpful for other developers as well: Docker #stop all containers: docker stop $(docker ps -a -q) # Restart docker service sudo systemctl restart docker.service Recreate all container docker-compose up –build –force-recreate –no-deps #stop all containers by force … Continue reading “Linux & Docker Commands Reference & Troubleshooting”
How to Block Google From Accessing a Staging Website
When you use a staging website for developing or testing purposes, you might be confronted with the question of what is the best way to protect your staging site from being indexed by Google. Since the first release of WP Staging, the staging site is protected by a custom authentication login prompt. We have always … Continue reading “How to Block Google From Accessing a Staging Website”
How to secure WordPress and Protect your Website from being Hacked
WordPress is the most popular content management system and website builder. That’s the reason why it is also the most attractive platform for bad guys and malicious plugins who target the WordPress platform. There is never a 100% guarantee that your site can not be hacked but there are some common steps you should go … Continue reading “How to secure WordPress and Protect your Website from being Hacked”
How to Repair mySQL Database with phpmyadmin and adminer
REPAIRING MYSQL DATABASES WITH PHPMYADMIN If your website behaves strangely, like throwing unknown errors, or cannot 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 repair MySQL database … Continue reading “How to Repair mySQL Database with phpmyadmin and adminer”
How to Clear Browser Cache and Cookies?
Modern Browsers like Safari, Firefox, and Chrome attempt to keep local copies of pages, images, JavaScript, and stylesheets. Doing that ensures that your browser does not need to download these pages or resources again later. Why is Clearing Browser Cache Necessary? Usually, browsers know when they need to refresh the cache but under certain circumstances, … Continue reading “How to Clear Browser Cache 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 that 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
We are doing a lot of work to please our 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 our team handles all the incoming support tickets. We … Continue reading “WP STAGING has an Astounding Review-to-Install Ratio”
MySQL Query – Delete all WooCommerce Bookings
If you need to delete all WooCommerce bookings that have the custom post type wc_booking you can use the MySQL query below:
MySQL Query: How to Delete all WooCommerce Orders
Use this MySQL query to delete all woocommerce orders at once from the MySQL command line. This can be useful if you want to delete all orders on your staging site and then import all orders again from the live site to make the staging site up to date before pushing it to the live … Continue reading “MySQL Query: How to Delete all WooCommerce Orders”