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…
Category: MySQL
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
MySQL Server Information
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
Code
Read more
Ubuntu – WordPress Install
These steps are based on Ubuntu 14.10 Server 64-bit but can be applied to virtually any Debian based UNIX distribution.
NPI Database
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…
MySQL to MSSQL Data Conversion
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…
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…
C# Backup and Restore MySQL Database(s)
Must Download DLLs from http://mysqlbackupnet.codeplex.com/
MySQL – Table/View Column Information
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.