mysqldump -h<host name> -u<username> -p<password> <db name> <table name> > my-dump.file

TIP: When dumping tables or databases, it’s worth adding –quote-names as a parameter, just in case you may have used a reserved word as a table or column name.

How to dump the contents of 1 table from MySQL into a file, that includes SQL type INSERT statements

Leave a Reply

Your email address will not be published. Required fields are marked *

− 5 = one