// archives

MySql

This tag is associated with 3 posts

got a packet bigger than ‘max_allowed_packet’ bytes

By admin ⋅ July 7, 2010 ⋅ Post a comment

Every time i changed the my.cnf file to 32M when I restarted the server the ‘max_allowed_packet’ variable was defaulted back to 1M

Select Yesterday from Unix Timestamp in MySql & PHP

By admin ⋅ May 19, 2010 ⋅ Post a comment

$yesterday = date(‘Y-m-d’, mktime (0,0,0,date(‘m’),(date(‘d’)-1),date(‘Y’))); WHERE var BETWEEN UNIX_TIMESTAMP(‘$yesterday 00:00:00′) AND UNIX_TIMESTAMP(‘$yesterday 23:59:59′)

Access MAMP MySql via Navicat

By admin ⋅ November 16, 2009 ⋅ Post a comment

Having just gone back to heavily using MAMP I was getting a little fed up with only being able to access the MySql database through phpMyAdmin so I figured I’d have a proper look at getting access through Navicat. I’d tried this hurriedly before – turns out it’s very simple. On your MAMP start screen [...]

—

Most Emailed