i was surfing around with a stupid search “mysql dump table” and *puff* google returns me with thousands of incredible results from python scripts to humble opinions on dumping like :
mysqldump -uUSER -pPASS –database DB –exclude.table ………
to sed scripts .
My search was just a test to checkout how many people – after 1 hour to simil sysadmin to explain how “man” works , and after a dump of a 19 GB table , so … the search was been a “must” .
Whatever , if your keyboard is broken and the three letters M A N doesn’t work will be forgiven… others i will help you with a simple extract from the manual :
mysqldump [options] [db_name [tbl_name …]]
that means :
command mysqldump can recieve options like username and password ( -u -p ) can be called for a database ( db_name ) and can be recieve for that database the file ( table ) where your super , critic data are stored .