WordPress is the strongest candidate out there when we talk about website builders. It provides almost every feature to build a professional and safe website. Every action in a WordPress site is interlinked with the database: Therefore, we need a secure connection to the database to keep hackers away from our valuable site data. Even … Continue reading “3 Ways to Change the WordPress Database Table Prefix”
Tag: database
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’? That indicates that there is not enough free space left on your hosting account, and WordPress cannot write new login information into the database. … 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, where you have to update the header and the SET properties to your needs: database name oldprefix_ newprefix_ This is the SQL query: SET @database = “databasename”; SET @oldprefix = “oldprefix_”; … Continue reading “How to Change WordPress Table Prefix of mySQL Database”
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 indicate a corrupted database table. Another indicator for a corrupted MySQL table … 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 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”
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 – 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”
Migrate WordPress Staging Site to Production Site
When you create a WordPress website using WP STAGING, there often comes a time when you want to migrate WordPress to your production website.This step-by-step guide will show you how to manually migrate WordPress to your production website. Please make sure you are tech savvy and know how to work with databases and files. Although … Continue reading “Migrate WordPress Staging Site to Production Site”