rakuishi · June 8, 2016 01:20
diff --git a/gistfile1.txt b/gistfile1.txt
 $ mkdir backup
 $ chmod 777 backup
 $ mysql -u root
 > USE [DATABASE_NAME];
 > SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') INTO OUTFILE "/backup/post_tag.csv" FIELDS TERMINATED BY "," ENCLOSED BY "\"" LINES TERMINATED BY "\n";
	$ mkdir backup
	$ chmod 777 backup
	$ mysql -u root
	> USE [DATABASE_NAME];
	> SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') INTO OUTFILE "/backup/post_tag.csv" FIELDS TERMINATED BY "," ENCLOSED BY "\"" LINES TERMINATED BY "\n";