mysqldump -h <host name> -u<username> -p<password> <db name> > my-dump.file
How to dump the entire contents of a database from MySQL into a file, that includes SQL type INSERT statements
- How do I extract the 1st position of a character string that are numbers and then order by number using MySQL
- How to dump the contents of 1 table from MySQL into a file, that includes SQL type INSERT statements