whoisgregg - 1:50 pm on Sep 14, 2011 (gmt 0)

I use this query:

$sql = "CREATE TABLE IF NOT EXISTS `backup_db`.`log_".$archive_year."` LIKE `main_db`.`log`;";

I also disable keys before dumps and enable keys after dumps to speed it up.