Skip to content

Instantly share code, notes, and snippets.

@jjack-vertex

jjack-vertex/mysql-dump-tables-by-prefix.txt

Forked from tofirius/mysql-dump-tables-by-prefix.txt
Last active December 8, 2020 03:10
Show Gist options
  • Save jjack-vertex/fda07379714125565aca43df2f0c3912 to your computer and use it in GitHub Desktop.
Save jjack-vertex/fda07379714125565aca43df2f0c3912 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL dump of tables that begin with a given prefix
Raw
mysql-dump-tables-by-prefix.txt
mysql database_name -u username -pPassword -N -e 'show tables like "tableprefix\_%"' | xargs mysqldump database_name -u username -pPassword > prefixedtable_dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment