MySQL will sometimes return the error message “Cannot load from mysql.proc. The table is probably corrupted”. This happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line.
Our Blog - Recent Launches, Freebies & General Ramblings
Tag Archives: MySQL
Using PHP’s var_dump() to Display SQL Query Results
Using the power of PHP’s var_dump() displays structured information about one or more expressions that includes its type and value. By definition var_dump() is a debugging tool, which displays structured information about any PHP variable. Below is a handy bit of code using var_dump() to test and verify that a SQL query contains data and view the contents using PHP:
$sql = mysql_query("SELECT * FROM your_table WHERE key = 'value'");
$assoc = mysql_fetch_assoc($sql);
// Dump variable containing the result of the MySQL query
var_dump($assoc);
Continue reading Using PHP’s var_dump() to Display SQL Query Results
11 Useful WordPress SQL Hacks For Maintaining Your Blog
WordPress is driven by a MySQL database which makes updating content cake once in the database. All of the WordPress data such as posts, comments, categories, and settings are stored within the MySQL database.
If you needed to change some information site wide, going through each and every record would prove a very time consuming task and also be prone to human error. By executing a SQL query against your WordPress database however, you can make the necessary changes quickly and efficiently.
We will show some SQL queries that can be of great assistance to you when using WordPress.
Continue reading 11 Useful WordPress SQL Hacks For Maintaining Your Blog