CODE EXAMPLE FOR PHP

cake php 2.x sql dump

$log = $this->User->getDataSource()->getLog(false, false);       
debug($log);