Skip to content

Instantly share code, notes, and snippets.

@joelremix

joelremix/backup_table

Created March 21, 2014 02:32
Show Gist options
  • Save joelremix/9678323 to your computer and use it in GitHub Desktop.
Save joelremix/9678323 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: backup_tables
Raw
backup_table
CREATE TABLE wp_posts_BAK LIKE wp_posts ;
INSERT wp_posts_BAK SELECT * FROM wp_posts;
CREATE TABLE wp_postmeta_BAK LIKE wp_postmeta ;
INSERT wp_postmeta_BAK SELECT * FROM wp_postmeta;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment