CODE EXAMPLE FOR PHP

cake php 2.x sql dump

$db =& ConnectionManager::getDataSource('default');
$db->showLog();