WordPress database error: [Can't create/write to file '/tmp/#sql_41b_0.MYI' (Errcode: 28)]SELECT t.*, tt.*, tr.object_id FROM qd_db_terms AS t INNER JOIN qd_db_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN qd_db_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (2135, 4582, 6585, 7142) ORDER BY t.name ASC
Last night I was creating some manual backups from a server including an entire web sites data files as well as the databases associated with that same web site. I decided to use the tar archiving utility to pack all of the files from the web site into a single file so it could be downloaded and stored easily. Use the information below to exclude a sub directory when creating a tar archive.
Earlier I was compiling the coreutils application on CentOS Linux and ran into an issue after using the “make” command. At first I was confused because I wasn’t doing anything complex but then I realized that I had simply mistyped an environment variable I had previously set. Below I describe the actual error, what was mistyped, and how I resolved the problem.
Working on a friends server earlier this morning I noticed that he had logrotate configured but he did not have a configuration file for Postfix. Below is the quick one I whipped up for his environment including a brief explanation of each line of the configuration file below the script. Following the explanation of the various configurations is the command to actually force logrotate to run in debug mode so you can see what happens.
Dump MySQL database: Use the below mysqldump command syntax to dump a single database from a MySQL
Dump One Table from a MySQL DB: The below syntax will dump one MySQL table including the SQL syntax needed to drop that table if it already exists in the database you eventually restore it to.