Repairing WordPress MySql Table corruption
- Nov
- 29
- Posted by TKH Specialist
- Posted in databases, MySql
We suffered a SAN outage which caused one of our wordpress servers to come back up with a corrupted table. In the wordpress logs this presented as: [error][client IP] Request exceeded the limit of 10 internal redirects due to probable configuration error. Use ‘LimitInternalRecursion’ to increase the limit if necessary. Use ‘LogLevel debug’ to get […]
read moreMySql, phpMyAdmin user creation and grant errors
- Jan
- 04
- Posted by TKH Specialist
- Posted in MySql, Troubleshooting
Recently I got a report from a user that they could not create a database using phpMyAdmin. When I logged in and did some testing I began getting errors when I attempted to create a user, a database or grant privileges as root… The root cause was a misalignment of the grants due to a […]
read moreMy MySQL Cheat Sheet
- Apr
- 23
- Posted by TKH Specialist
- Posted in MySql, redhat, System Administration
I know, man. No, I mean I know I could use ‘man pages’! Or I could just ‘google it’ but then it isn’t mine. Since I do not have time for a complete brain-dump this MySql “cheat sheet” will grow over time. Feel free to add your favorite MySql commands in the comments, if their […]
read moreMySQLi
- Jun
- 05
- Posted by TKH Specialist
- Posted in MySql, PHP
MySQLi (MySQL Improved) has many advantages over the older PHP MySQL driver. It takes advantage the newer features built into MySQL 4.1.3 and newer. Below are some simple examples of basic MySQL functions (SELECT, INSERT, UPDATE and DELETE). SELECT $mysqli = new mysqli(‘$server’, ‘$user’, ‘$pass’, ‘$db’); if (mysqli_connect_errno()) { printf (“Connect failed: %sn”, mysqli_connect_error()); exit(); […]
read moreRecent Comments
- Stefan on Flush This!
- Timestamping your Bash History | Matt's Entropy on Remember when you issued that command…?
- Matt Smith on Remember when you issued that command…?
- Ruan on Putting ‘lsof’ to use
- Dylan F. Marquis on External Mapping of LDAP attributes in CAS