How To – Fix MySQL Option Without Preceding Group

Posted on by
Reply

Background Knowledge

Dock Icon By Presto X

You try starting, stopping or connecting to MySQL and receive the following error, “Error: Found option without preceding group in config file: /etc/mysql/conf.d/char_collation_set.cnf at line: 1″. The error message my vary but comes to the same issue. MySQL may not start or might experience connectivity issues.

This issue was experienced on Debian Squeeze v6.04 AMD64 system with MySQL v14.14 Distrib 5.1.61.

Solution

This issue is caused by a improperly formatted MySQL configuration file(s) and refers to one missing the group heading (e.g. [mysqld], [mysqld_safe], etc.).

Source: MySQL 5.1 Reference Manual :: 4.2.3.3. Using Option Files
Source: [Solved] Mysql won’t start. my.cnf problem.

How To – Add Week Numbers to Microsoft Outlook Calendar

Posted on by
Reply

Background Knowledge

At times one may need to quickly reference what the week number is for a given week. The steps below will describe how to add week numbers to the calendar in Microsoft Outlook.

Solution for Microsoft Outlook 2003 and 2007 Calendar

  1. Click on the menu “Tools” then “Options”.
  2. Under “Preferences” tab click on the button “Calendar Options…”.
  3. Under “Calendar Options” place a check mark on “Show week numbers in the month view and in the Date Navigator”.
  4. Click on the “OK” button.
  5. Click on the “OK” button.

Solution for Microsoft Outlook 2010 Calendar

  1. Click on the menu “File” then “Options”.
  2. Click on Calendar.
  3. Under “Display Options”, place a check mark on “Show week numbers in the month view and in the Date Navigator”.
  4. Click on the “OK” button.

Source: Add week numbers to Microsoft Outlook Calendar [How-To]

Alma

Posted on by

Alma from Rodrigo Blaas on Vimeo.

Full Screen recommended

Written and Directed by: Rodrigo Blaas
Produced by: Cecile Hokes
Music: Mastretta
Art Director: Alfonso Blaas
Lighting Supervisor: Jonatan Catalán
Character Technical Supervisor: Jaime Maestro
Character Design: Bolhem Bouchiba, Carlos Grangel,
Sergio Pablos, Santi Agustí
Animation: Daniel Peixe, ManueBover, Remi Hueso
Sound Design: Tom Myers and David Hughes
Post Production Coordinator: David Heras
Special Thanks: Keytoon, Next Limit, UserT38

Full credits: almashortfilm.com

How To – Resolve MySQL Error Incorrect Key File for Table

Posted on by
1

Background Knowledge

I using PHP v5.3.3-7 PDO running a MySQL v14.14 Distrib 5.1.49 on Debian v6.0.4 64-bit and executing a SQL load data infile statement.

I received “PHP Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 126 Incorrect key file for table ‘/tmp/#sql_66f_0.MYI’; try to repair it”. My database table in this instance is using the storage engine of InnoDB and therefore one can not use the “repair table”.

From my experience I’ve found that this error can mean one of two issues however I have not found information from MySQL confirming this.

Solution – Repair Table

The error message may mean the database table is corrupted and requires a repair.

  1. Run repair table on the associated database table.
  2. Re-run the previous query.
  3. The issue will now be resolved.

Solution – Free Disk Space

The error message may mean the system does not have enough free disk space.

  1. Verify the free disk space. On Linux execute at the console “df -h”. On Windows open “My Computer” to see free space available.
  2. If low or out of disk space, free up some space or follow the next steps to change MySQL server setting to point to a new temporary path.
  3. Edit the MySQL server configuration file, my.cnf (on Debian, /etc/mysql/my.cnf).
  4. Change the “tmpdir” path variable to a new location with more available free disk space (ex. /var/tmp or D:\temp).
  5. Stop MySQL daemon/service and then start MySQL daemon/service for the configuration changes to take affect.