User:Kelson/Memo
Jump to navigation
Jump to search
MySQL
# Get table list with prefix
mysql -N information_schema -ufoouser -pfoopass -e "SELECT table_name FROM tables where table_schema='foodb' AND table_name like 'prefix_%'" > tables.txt
# Dump DB without triggers
mysqldump --skip-triggers -ufoouser -pfoopass foobar | xz > foobar.notriggers.sql.xz