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:
- dump one table:
mysqldump dumped_database -u root --password --tables table_to_dump -r=file_dump_name.sql
- dump one table without DROP TABLE command in dump file:
mysqldump dumped_database -u root --password --tables table_to_dump -r=file_dump_name.sql --add-drop-table=FALSE
We 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
