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
code type:
