Dumping your database data to a file

To dump the full data to a file use this command:

mysqldump --skip-extended-insert -u admin20154iwg -p developiwg > iwgit-data.sql

-u -> for username
-p -> to prompt the password

To dump the data without temporary data to a file use this command:

mysqldump --skip-extended-insert -u admin20154iwg -p --ignore-table=developiwg.cache% --ignore-table=developiwg.search% --ignore-table=developiwg.watchdog developiwg > iwgit-data.sql