I was super excited to find this little utility that splits up large SQL files. I was at my wits’ end trying to load an export into a database, and this did the trick very nicely.
I’ve been troubleshooting a client’s connection to his websites on a VPS server, and found this spectacular resource. He says his internet is MUCH faster now that we’ve changed the DNS settings on his computer.
I originally got to that page from here: How to Fix the “Server DNS Address Could Not Be Found” Error In Google Chrome
I’m posting this so I can take a look at it when I have time:
Google doesn’t like links from low-quality sites, so telling them this is not a site I know or trust is a good thing.
Siteground support gave me a good resource today… a website previewer that can be used to see a site before you’re ready to switch the DNS.
Here’s a good article on how to diagnose and fix slow WordPress sites.
We recently had a client with a hacked site, and I discovered some interesting security tools that are freely available.
And here are some more…
I used some of them to make sure the site had been cleaned up, and all is well. This underscores the importance of keeping WordPress up-to-date!
I wanted to find out which domains were on somebody’s mailing list, and used this SQL command:
SELECT count((SUBSTRING_INDEX(SUBSTR(email, INSTR(email, ‘@’) + 1),’.’,1))), (SUBSTRING_INDEX(SUBSTR(email, INSTR(email, ‘@’) + 1),’.’,1)) FROM `phplist_user_user` group by (SUBSTRING_INDEX(SUBSTR(email, INSTR(email, ‘@’) + 1),’.’,1)) where confirmed=1 and blacklisted=0 order by count(SUBSTRING_INDEX(SUBSTR(email, INSTR(email, ‘@’) + 1),’.’,1)) desc
It resulted in this list. Pretty cool!
Recently, I’ve been learning about email and how to set things up so people can’t impersonate email addresses.
One of the things to set up is DKIM, which is a method of “signing” an email as it leaves your server. The recipient end can validate that signature when email is received, and if it fails the validation, the email can be rejected as not legitimate.
This site can be used to test if your DKIM signature is set up correctly:
Another way to test is to send it to your Yahoo email, then look at the message source. If you find “dkim=pass” in the header, you’re good to go.
And, one more way is to send an email to email@example.com and you’ll get a report back.
Additional resource: https://emailstuff.org/