Backups and migrations

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.

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…