Friday, February 14, 2014

MySQL is not starting. Operating system error number 2 in a file operation

Here is the error log.

2013-11-18 21:25:25 a171e1a8  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./testdb/dr_actions.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.

Step 1. Open mysql configuration file, mine is /opt/lampp/etc/my.cnf

Step 2. In [mysqld] section, add the following line:
innodb_force_recovery = 1

Step 3. Save the file and try starting MySQL

Step 4. Remove that line which you just added and Save. 

Wednesday, February 5, 2014

Move Window Control Buttons to the Right Ubuntu 12.04

For Ubuntu 12.04

1.  In the Terminal, enter this code sudo apt-get install gconf-editor to install Configuration Editor if it's not in your system.

2.  Press Alt-F2, then type gconf-editor into the box, and press Enter to run it.

3.  Browse to apps > metacity > general, look for "button_layout" on the right panel.

4.  Change the value in the "button_layout" from close,minimize,maximize: to :minimize,maximize,close   and press the Enter key.


The above works for all control buttons on non-maximized windows. When a window is maximized, the control buttons are however fixed to the left of the Global Menu.


Note: If dconf-editor is not available, you can install it by running sudo apt-get install dconf-tools in the Terminal.