MySQL : Dumping Data in SQL Format with mysqldump
MySQL : Dumping Data in SQL Format with mysqldump By default, mysqldump writes information as SQL statements to the standard output. You can save the output in a file: shell> mysqldump [arguments] > file_name To dump all databases, invoke mysqldump with the –all-databases option: shell> mysqldump –all-databases > dump.sql To dump only specific databases, name them on the command line … Read more