Was in need to dump tables with certain prefix with via shell. I used this script:<\/p>\n
Did this on MYSQL 5.0.45.<\/p>\n","protected":false},"excerpt":{"rendered":" Was in need to dump tables with certain prefix with via shell. I used this script: # Replace DBNAME, USERNAME, PASSWORD with your values. db=DBNAME…<\/p>\n# Replace DBNAME, USERNAME, PASSWORD with your values.
\ndb=DBNAME
\necho Tell me the prefix.
\nread prae
\ntest=`mysql -u USERNAME --password=PASSWORD $db --execute=\"SHOW TABLES LIKE '$prae%'\"`
\n# the test string produces undesirable output at the beginning, the following lines of code extract them, not elegant, but works.
\nl=`expr length $db`
\nm=`expr length $prae`
\nz=$(($l+$m+15))
\ntest3=${test:$z}
\necho Tables: $test3
\nmysqldump -u USERNAME --password=PASSWORD --opt --databases $db --tables $test3 > ${prae}.sql
\necho Data saved.<\/code><\/p>\n