Month: June 2006

[problem]

You want to create a favicon.ico from Unix.

[/problem]

[solution]

1. Open your image with GIMP
2. If your image is not a square then resize the canvas with GIMP
3. Scale the image to 16×16 pixel (Image, Scale image)
4. Save as favicon.pnm or favicon.ppm with raw encoding
5. Close GIMP

[/solution]

[example]

Then to convert favicon.pnm or favicon.ppm using the command line utility ppmtowinicon:

$ ppmtowinicon -output favicon.ico favicon.pnm

Or

$ ppmtowinicon -output favicon.ico favicon.ppm

[/example]

[reference]

Kewl tip on creating a favicon.ico with ppmtowinico – thanks to linuxproblem.org. 🙂

http://www.linuxproblem.org/art_19.html

[/reference]

[problem]

One annoying thing I recently discovered, when copying code from my blogs (yes I use my own tips too! 🙂 ), quotes seem to turn into dots. Both for single and double quotes.

[/problem]

[solution]

The answer to this was explained in a blogging book, that apparently the quotes on a keyboard refer to feet and inches – not speech! 😉

The solution is simply to use ASCII notation.

[/solution]

[example]

Therefore a double quote becomes " and a single '

[/example]

[reference]

[/reference]

[problem]

You want to perform command line display of mysql dbs with mysqlshow.

[/problem]

[solution]

Is this demo, I show the options for mysqlshow.

mysqlshow is a real easy way to quickly view your dbs, tables and rows.

[/solution]

[example]

Show Databases

$ mysqlshow -i -u'root' -p'xxxxxx'
+---------------+
|   Databases   |
+---------------+
| demo          |
| mysql         |
| test          |
+---------------+

Show number of tables under each db

$ mysqlshow -v -i -u'root' -p'xxxxx'
+---------------+--------+
|   Databases   | Tables |
+---------------+--------+
| demo          |      1 |
| mysql         |     15 |
| test          |      0 |
+---------------+--------+
5 rows in set.

Show total number of rows for each db

[[email protected] ~]$ mysqlshow -v -v -i -u'root' -p'xxxxx'
+---------------+--------+--------------+
|   Databases   | Tables |  Total Rows  |
+---------------+--------+--------------+
| demo          |      1 |            7 |
| mysql         |     15 |         1383 |
| test          |      0 |            0 |
+---------------+--------+--------------+
5 rows in set.

[/example]

[problem]

You want to know how to do the following, through mysql command line interface:

Connect to the mysql daemon

Show the databases your user has access

Show tables defined under that db

Show schema for given table

[/problem]

[example]

mysql -u'username' -p'password' -h'mysql_host'

mysql_host is optional if the daemon is running on the same host.

Show databases

show databases;

Show tables

show tables;

Describe tables

use demo;
describe demo;

For example:

mysql> show databases;
+----------+
| Database |
+----------+
| demo     |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> use demo;

Database changed
mysql> show tables;
+----------------+
| Tables_in_demo |
+----------------+
| demo_table     |
+----------------+
1 row in set (0.00 sec)

mysql> desc demo_table;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | mediumint(9) |      | PRI | 0       |       |
| day   | varchar(20)  |      |     |         |       |
| val   | tinyint(4)   |      |     | 0       |       |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.10 sec)

[/example]

[problem]

You want a simple bit of java code that takes arguments from the command line and displays them.

[/problem]

[solution]

Good demo on how to obtain and handle java arguments.

public class Arguments {

  public static void main(String argv[]) {

    if(argv.length > 0) {

      System.out.println("args exec w " + argv.length + " args");

        for(int i=0;i...

[/solution]

[example]

Here is a demo:

# java Arguments -a -x -y
args exec w 3 args
argv[0] = -a
argv[1] = -x
argv[2] = -y

[/example]