User:Kelson/Memo: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== MySQL == <source lang="bash"> # Dump DB without triggers mysqldump --skip-triggers -ufoouser -pfoopass foobar | xz > foobar.notriggers.sql.xz </source>") |
No edit summary |
||
| Line 1: | Line 1: | ||
== MySQL == | == MySQL == | ||
<source lang="bash"> | <source lang="bash"> | ||
# 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 | # Dump DB without triggers | ||
mysqldump --skip-triggers -ufoouser -pfoopass foobar | xz > foobar.notriggers.sql.xz | mysqldump --skip-triggers -ufoouser -pfoopass foobar | xz > foobar.notriggers.sql.xz | ||
</source> | </source> | ||
Revision as of 18:20, 13 March 2013
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