Duplicating a MySQL table schema and data

/* Create a new table from foo's schema */
> CREATE TABLE foo_20150904 LIKE foo;

/* Insert whole data into a new table */
> INSERT INTO foo_20150904 SELECT * FROM foo;