command export database mysql to local mac code example

Example 1: mysql export database command line

mysqldump -uroot -p root YourDatabaseName > WantedSQLFile.sql

Example 2: import all databases mysql

# Import
mysql -u root -p < all.sql