GeoNames Data Dump Files – Usage Example
This is an example of how to use the GeoNames data dump … Read more →
Archive for “MySQL”
MySQL commands and SQL queries to help you manage your MySQL databases and tables.
MySQL Queries To Change WordPress From HTTP to HTTPS In The Database
There is some bad advice going around regarding updating URLs in the … Read more →
SQL Query – Change siteurl in wp_options Table For All Sites in WP Multisite
These SQL queries let you change the value for “siteurl” option in … Read more →
MySQL Command Line Cheat Sheet
These are my most often used MySQL commands and queries. Jump down … Read more →
Reset MySQL root password in Ubuntu/Linux Command Line
These are the terminal commands to reset your MySQL password for your … Read more →
SQL Query – Change home url in wp_options for all sites in WP Multisite
These are SQL queries to change the home url in the wp_options … Read more →
Change Custom Menu Links in WP from HTTP to HTTPS via MySQL
This is useful if you created custom menu links for your WordPress … Read more →
Delete All Attachments of Specified Date in WordPress Database
These are MySQL statements to bulk delete all WordPress attachments of a … Read more →
Insert Data Array Into MySQL Table Using PHP
Updated to use MySQL transactions, prepared SQL statments, and bound parameters. This … Read more →
Subscribe Existing Commentators Into Comment Notifier Plugin
This is for you if you are using the WordPress Comment Notifier … Read more →