mysqldump Dumping Data in SQL Format on Ubuntu Server #132


In this tutorial I will show you show to dump data in SQL format on Ubuntu Server using mysqldump command. The discussed topics on this tutorial are: Invocation Syntax, Specify MySQL credentials, Save the output in a file, Working with multiple databases, Table structure options, Table data options, Format options, mysqldump info, –option-value and –skip-option-value and Man page.

Code used during this tutorial:

Useful links:
https://github.com/liviubalan/liviubalan.com-vagrant-ubuntu
http://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
http://stackoverflow.com/questions/12439353/mysqldump-one-insert-statement-for-each-data-row