WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_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 (24) ORDER BY t.name ASC

Auto Update CentOS | Data Networking Blog

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (13) ORDER BY t.name ASC

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (31) ORDER BY t.name ASC

Data Networking Blog
Blog for Admins

Auto Update CentOS

Standard

Updating systems is an important part of day to day administration. Normally you plan your updates and check compatibility with a lot of other software running on your server before applying updates so if you are thinking about auto updating a critical server then I would advise against it. Why? There are a lot of reasons. Check this link for a good explanation with pros and cons.

I do this on my personal servers as I can afford a little bit of a down time in case something goes wrong but that hasn’t happened yet.  So let’s start by install yum-cron

The configuration is in the directory /etc/sysconfig/. You won’t have to change much in the configuration file so I would suggest changing only the email address.

Change the MAILTO directive and provide a valid email if you want it delivered to local root mailbox.

Now add it to system startup list and start the service.

There you go, now your system will stay updated without you having to worry about it. I like auto update as CentOS provides stable software versions and updates are available when a vulnerability is found and I don’t get the time to logon everyday.

Check the yum-cron manual page for more details.

February 5, 2015 Uncategorised Jd

Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Font Size
Decrease Size Default Size Increase Size
Select Skin
Select Underlay Background
Select Overlay Background
Scheme Switcher Toggle