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”