mysql command line client code example

Example 1: xampp import sql file command line

C:\xampp\mysql\bin>mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql

Example 2: mysql export database command line

mysqldump --databases --user=root --password your_db_name > export_into_db.sql