[21:30] I have installed mysql 5.1.20. I can't start mysqld or mysqld_safe. I am getting following errors: [21:30],tin> 070721 16:08:15 mysqld_safe Starting mysqld daemon with databases from /home/me/mysql/mysql-cluster [21:30] ^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) [21:30] 070721 16:08:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. [21:30] !perror 13 [21:30] OS error code 13: Permission denied [21:30] * rook2pawn has quit IRC () [21:30] set datadir owner to mysql user [21:31] ok...thanks. [21:32] also...i searched for mysql.sock, there is none on my system. Is this normal for 5.1.20? [21:33] mysql.sock is created when mysqld starts and destroyed when it exits [21:33] if mysqld isn't running it won't exist [21:33] okey dokey..thanks. [21:33] I lost my mysql.sock before, just disappeared.....currently doing a backup restore [21:33] I couldnt access my db at all [21:33] sm_force: in the dryer? [21:33] chadmaynard: yeah i think datetime is fine for us. i don't see anything about how its stored in the database though, at least not on the date/time page in the mysql docs [21:33] I think the dog ran off with it [21:34] * drwhat (n=virsys@or-71-54-198-12.dhcp.embarqhsd.net) has joined #mysql [21:34] * tintin has quit IRC ("Download Gaim: http://gaim.sourceforge.net/") [21:34] chadmaynard: oh now i see. datetime is 8 bytes, timestamp is 4 bytes [21:34] cmorgan: maybe it's on the mysql performance page.... [21:34] chadmaynard: ahh and how its packed makes sense too [21:35] chadmaynard: http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html