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”

How to Backup WordPress Website Manually using cPanel

I’m sure you love your website and can’t afford to lose it. Every website can get hacked or attacked by malicious software. Especially, WordPress websites are a lucrative target for attackers. There are more than 200 million WordPress sites reachable, and more than 14.7% of the world’s Top 100 Websites are based on WordPress. (At … Continue reading “How to Backup WordPress Website Manually using cPanel”

WPML error due to missing index: Table wp_options is filled up with multiple entries of wpml_translation_services

One of our users was running WP Staging Pro alongside WPML (inc. translation management) on a couple of websites. On one, in particular, pushing the staging to live site using WP Staging Pro immediately causes the wp_options table to fill up with entries with the wp_name of ‘wpml_translation_services‘. As soon as these were deleted, no … Continue reading “WPML error due to missing index: Table wp_options is filled up with multiple entries of wpml_translation_services”

phpMyAdmin Repair and Optimize Database Tables Tutorial

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 be an indicator for a corrupted database table. Another indicator for a … Continue reading “phpMyAdmin Repair and Optimize Database Tables Tutorial”

How to Repair mySQL Database with phpmyadmin and adminer

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”

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”

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”

Migrate WordPress Staging Site to Production Site

Whenever you create a WordPress website with WP Staging, there often comes the time that you want to migrate WordPress to your production website. In that step by step guide, I’ll show you how you can migrate WordPress to your live website manually without using any extra tool. If you like to migrate WordPress automatically … Continue reading “Migrate WordPress Staging Site to Production Site”