mysql dump to local mysql code example

Example 1: connect to mysql localhost from the mysql shell

\connect root@localhost:3306

Example 2: mysqldump cli command

Press CTRL+C to copy shell> mysqldump --databases db1 db2 db3 > dump.sql