2pnl4a
Last Updated: February 25, 2016
·
2.125K
· av4tar
A3ac6be8b8254ce468a61b59c43083ff

rotating tables in mysql

Want to rotate a table used for log data? Don't delete records (that will suck) just rename it:

create table new_logtable like logtable;
rename table logtable to logtable_20121127, new_logtable to logtable;
Say Thanks
Respond