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 that doesn’t seem to make…
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
SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc. SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc. References: http://stackoverflow.com/questions/3939803/how-to-get-mysql-server-info-using-command-line
These steps are based on Ubuntu 14.10 Server 64-bit but can be applied to virtually any Debian based UNIX distribution.
If you work in medical databases you are likely familiar with the site CMS NPI Search I have had a few projects that need the ability to validate NPI numbers so based on data at CMS.gov I have worked out a solution to get the data into a database that I can manage. CSVKit is…
Ever have to take a MySQL database and put it in Microsoft SQL? This is a MySQL dump script that will assist you in this conversion. Only problem that I’ve had with it is that you need to review the exported SQL and make sure your version of Microsoft SQL will accept it.
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 first update your wp-config.php Secondly…
Must Download DLLs from http://mysqlbackupnet.codeplex.com/
Similar to MSSQL – Table/View Column Information, this post will help with MySQL tables and columns. This query is a quick query to give you the pertinent information about a specific table.