Skip to content

Instantly share code, notes, and snippets.

@ylacancellera

ylacancellera/mysql_restore_mysqldump_single_table

Last active January 20, 2022 14:33
Show Gist options
  • Save ylacancellera/7bbbefefb55d83b12b5343ead32743ee to your computer and use it in GitHub Desktop.
Save ylacancellera/7bbbefefb55d83b12b5343ead32743ee to your computer and use it in GitHub Desktop.
Download ZIP
mysql_restaure_single_table
Raw
mysql_restore_mysqldump_single_table
echo "set session sql_log_bin='OFF' > table.sql
sed -n -e '/-- Table structure for table `<Table Name>`/,/UNLOCK TABLES/p' <SQL File> >> table.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment