After writing WordPress – Backup & Restore I came across a site that I do not have SSH/CLI access to so I needed to have another option. If you have SSH/CLI access it’s best to use the process on WordPress – Backup & Restore. Sometimes you just need a quick…
Category: WordPress SQL
MySQL – WordPress Multisite Settings
Currently this is not an ideal process but will provide needed information. First get a list of all of the site’s option tables. Typically the main/root site will be wp_options and sub-sequential sites will be wp_2_options, wp_3_options, etc. The results should look similar to this: Once we have the tables…
WordPress – Ninja Forms – Disable Form Saves
If you have a concern about PHI or other concerns of saving data on your SQL database of the Ninja Forms follow the step on their site http://docs.ninjaforms.com/customer/en/portal/articles/2045697-faq#faq_save on the save-sub.php file. The save-sub.php location may vary based on your operating system but if you are on a UNIX based…
PHP WordPress – Use Radius Server Login
Securing WordPress with Radius Server login. This project was created in mind to help secure WordPress but allow users an easier way to securely login without having to have a really long password to remember. While I do not go into creating the Radius server you can go to http://www.radiusdesk.com/getting_started/install_ubuntu_nginx…
MySQL Procedure Get WordPress Site Name
If you manage many WordPress site databases it can get a bit crazy to know which site goes with what database but it gets more “fun” when you have a network site, below I attempt to help document some ways to help. This first example is a rather long process…
WordPress Database Information
I plan to work more on this as it is rather nasty but as a work in progress notepad if you will this is the spot for now. GitHub: https://gist.github.com/dkittell/f9080101d66834910dfd
WordPress Change URL – MySQL – Update String Within Column
Recently I changed a domain alias for a WordPress site and needed to change the domain in all the pages/posts and this little script came in handy. Typical disclaimer stands, do a full backup before running this and verify you have everything setup correctly. If you have a network site…