Skip to content

Instantly share code, notes, and snippets.

@k12u
Created December 21, 2011 13:49
Show Gist options
  • Save k12u/1506123 to your computer and use it in GitHub Desktop.
Save k12u/1506123 to your computer and use it in GitHub Desktop.
partial mysqldump
$ mysqldump -t -n --compact -hdbserver -uuser_id \
db_name table_name -w 'row_id = 111'
--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES (ry
--
INSERT INTO `table_name` VALUES (111,0,0,0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment