Page is a not externally linkable
- Code, Content, and Presentation
---- Large log table, what would a DBA do?
whoisgregg - 1:50 pm on Sep 14, 2011 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4361515.htm
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.
Brought to you by WebmasterWorld: http://www.webmasterworld.com