Category: MySQL

Get links to posts that contain specific phrase Hi all! Today, we continue review questions regarding SEO. Let’s imagine we have a large website, which has thousands pages. And we should find certain word or part of this word in the posts content. In addition, we should output all links of the pages that contain…

Replace string or add symbol on all WordPress site Sometimes as a result of rebranding company or just banal inattention there is a need to replace string or add/change some symbol in the word. For example, in my case it was replace “Company Name” to “Company Name®”. Well, traditionally here are some ways resolve this…

Quickly change post type or taxonomy It’s a matter of special satisfaction to me that, some tasks which resolve use special plugins, are can be resolved faster, than time spent for download and activate this plugin.

Error when export data base Once at time on the blog pages, we already considered export/import large files to MySQL. Sometime, if this operations does on the customer side and you have limited rights there, you can faced with error: mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this…

How increase the redo log size using innodb_log_file_size? In the last article, we considered how we can import big database to MySQL. In the import process, we may get many related bugs, one of them ERROR 1118 (42000) at line 354585: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of…

Import large SQL databases into MySQL As rules, the bulk of all WordPress sites have small database. When I say “small”, I mean until 100 MB. But if we say about e-shops or for example about news portals, size of database may exceed several hundred megabytes. If you try import such file, you probably get…