MySQL and the WordPress database

mysqldump error: Access denied, you need the PROCESS privilege We have already looked at export and import of large SQL files in MySQL. Sometimes these operations are done on the client’s server, where your database user has limited rights, and mysqldump stops with an error: mysqldump: Error: ‘Access denied; you need (at least one of)…

Get links to all posts that contain a specific phrase Hi all! Today we continue with SEO questions. Imagine a large website with thousands of pages. We have to find a word, or a part of a word, in the content of the posts, output links to all pages that contain it, and then be…

Avoid N+1 queries in WordPress: prime the meta and term caches The N+1 problem: one query fetches a list of N items, and then every item in a loop makes one more query for its related data. With 50 posts that is 51 queries, with 200 posts it is 201. In WordPress it usually happens…

Replace a string in the whole WordPress database Sometimes, because of a company rebranding or simple inattention, a string has to be replaced everywhere on the site, or a symbol added to a word. In my case “Company Name” had to become “Company Name®”. Traditionally, there are several ways to do it.

Quickly change the post type or taxonomy with SQL It gives me special satisfaction when a task that people solve with a plugin can be done faster than it takes to download and activate that plugin.

How to fix MySQL ERROR 1118 (42000): increase innodb_log_file_size In the previous article, we looked at how to import a large database into MySQL via the command line. During that process, you might hit another error: ERROR 1118 (42000) at line 354585: The size of BLOB/TEXT data inserted in one transaction is greater than 10%…

Import large SQL databases into MySQL As a rule, most WordPress sites have small databases, and by “small” I mean under 100 MB. But e-commerce stores and news portals can easily grow to several hundred megabytes. Trying to import a file that size through phpMyAdmin usually ends with an error: the upload size limit, the…

ACF link field values lost after database migration Migrating a WordPress database from production to local, or between servers, is routine. But ACF Link fields store absolute URLs inside serialized arrays, which means a plain search-and-replace in phpMyAdmin will corrupt the data. Here’s how to handle it properly.