Last_Error: Error 'Unknown or incorrect time zone: 'Etc/UTC'' on query. Default database: 'db_name'. Query: 'INSERT INTO table SET column = CONVERT_TZ('2009-01-24', '-8:00', '+00:00')'

It’s a simple fix. Exit out of MySQL and run the following command - this works on Redhat, I’ve not tried it on other flavors.

shell> mysql_tzinfo_to_sql /usr/share/zoneinfo|mysql -u root -p

When optimizing queries by rewriting them to different forms that should return the same results, you can verify that you get the same results by taking a checksum of them.

Just set your pager to md5sum:

mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from test;
a09bc56ac9aa0cbcc659c3d566c2c7e4 -
4096 rows in set (0.00 sec)

# at -v 03:00 -f /root/shantanu/testat.sh > /root/shantanu/testat_result.txt 2>&1
# atq
7 2009-03-14 03:00 a root

`test -s /var/log/mailme.txt`
if [[ $? -eq 0 ]] ; then
The above 2 lines can be written in one line as shown below:

if [[ -z /var/log/mailme.txt ]]; then

#!/bin/sh
awk -F"," '{print $1,$2}' read1.txt | while read var1 var2
do
echo $var1 $var2
done

30 0 * * * updatedb > /dev/null 2>&1

# Clock synchronization
30 10 * * * CTIPDGT=`/sbin/ifconfig | grep -m 1 "inet addr" | grep -o "17.2.[0,8,26,32,40,56,16,40,56].*" | cut -d "." -f3`; /usr/sbin/ntpdate -u 172.29.${CTIPDGT}.123; /sbin/hwclock --systohc > /dev/null 2>&1

The declare command can be helpful in identifying variables, environmental or otherwise. This can be especially useful with arrays.

bash$ declare | grep HOME
/home/bozo

bash$ zzy=68
bash$ declare | grep zzy
zzy=68

bash$ Colors=([0]="purple" [1]="reddish-orange" [2]="light green")
bash$ echo ${Colors[@]}
purple reddish-orange light green
bash$ declare | grep Colors
Colors=([0]="purple" [1]="reddish-orange" [2]="light green")

When you have your mysql up and running, just connect to any database (like mysql or test) and perform a following command:

CREATE TABLE innodb_table_monitor(x int) engine=innodb;

This will force innodb engine to start table monitor and dump some useful data regarding your tablespaces in mysql's error log

$ watch --interval=1 --differences 'mysql -uuser -ppassword -e "show slave status\G"'

# vi /bin/findtable

#!bin/sh

mysql -e"select TABLE_SCHEMA, TABLE_NAME, ENGINE, TABLE_ROWS, CREATE_TIME FROM information_schema.TABLES where TABLE_NAME LIKE '%$1%';"

# chmod 777 /bin/findtable

# sh findtable test