i.justrealized

There are generally 2 ways of repairing MySQL tables using the command line. First is to use “mysqlcheck“, the other is to use “myisamchk” (only for MyISAM). This is more for my own information.

This has been tested on Ubuntu 9.10 with MySQL 5

mysqlcheck

This is how you can check if your database tables are fine:

Change “Username” to your username and “Secret” to your password.

To repair them, use:

This requires of your MySQL daemon to be running. If it isn’t running use this to start:

myisamchk

If you have trouble running ‘mysqlcheck’, you can consider using ‘myisamchk’ instead if your tables are MyISAM. This command can be performed without MySQL daemon running. This fixes the data in your file system directly and this has saved me once.

Change “db_name” to your database name and “table_name” to the name of the table you wish to repair.

I just realized I totally used up my disk space in my slice:

It has never occurred to me that this would happen. I start to do some clearing up and delete some backups that I no longer need.

I managed to free more than 2 Gb.

I can resist no more and upgraded my Ubuntu 9.04 Jaunty Jackalope to Ubuntu 9.10 Karmic Koala Release Candidate.

To do the same, press Alt + F2 to open up the Run Application window and type in “upgrade-manager -d” without quotation.

This is a personal note. This lets you check Ubuntu’s version number. Run the command ‘cat /etc/lsb-release’.

My blog has pretty much become a scrap book.

To find Red Hat or CentOS linux version number use:

jer added that this is a better alternative:

Thanks!

Woah, Ubuntu is aiming for a 10-second boot time. Nobody would complain for a faster operating system.

Ubuntu aims for ten-second boot time with 10.04

The growing adoption of the Linux operating system on netbook devices has compelled Linux distributors to focus on improving startup performance. Ubuntu 9.04, which was released last month, is one distribution where these improvements are particularly noticeable.

The developers behind the Ubuntu Linux distribution aim to significantly improve boot performance. Their ambitious goal for 2010 is to reduce total boot time to 10 seconds. (Source: Ars)

On a side note, I just ordered a MacBook Pro.

Ubuntu’s bug number 1 is reported by Mark Shuttleworth, founder of Canonical Ltd. and as of 2009, provides leadership for the Ubuntu operating system.

Bug #1 in Ubuntu: “Microsoft has a majority market share”

Microsoft has a majority market share in the new desktop PC marketplace.

This is a bug, which Ubuntu is designed to fix.

Non-free software is holding back innovation in the IT industry, restricting access to IT to a small part of the world’s population and limiting the ability of software developers to reach their full potential, globally. This bug is widely evident in the PC industry.

Steps to repeat:

1. Visit a local PC store.

What happens:

1. Observe that a majority of PCs for sale have non-free software pre-installed.
2. Observe very few PCs with Ubuntu and free software pre-installed.

What should happen:

1. A majority of the PCs for sale should include only free software like Ubuntu.
2. Ubuntu should be marketed in a way such that its amazing features and benefits would be apparent and known by all.
3. The system shall become more and more user friendly as time passes.

(Source: Launchpad)

Let’s face it, Firefox isn’t exactly the fastest browser around. In Linux it’s worse, in fact, Windows Firefox through Wine in Linux is faster than Linux Firefox.

Tuxradar benchmark Firefox 3.5 Beta 4′s performance and the results are very optimistic.

I use Firefox and Opera in Ubuntu and I prefer Opera in terms of speed but it just never felt quite like a native application in Ubuntu. Firefox just doesn’t appear as responsive sometimes.