Database export is very usefull in the situations when we want to restore database from some precised point in the past. To do that in command line, we can use mysqldump command. They're different samples with this command:
mysqldump dumped_database -u root --password --tables table_to_dump -r=file_dump_name.sql
mysqldump dumped_database -u root --password --tables table_to_dump -r=file_dump_name.sql --add-drop-table=FALSEWe can also use a simple mysql command used to connect to one database, and add > dumpFile.sql at the end of the command:
mysqldump -u root dumped_database --password dumped_table > dump_file.sql