Import SQL File into MySQL in XAMPP from Command Line in MacOS

To import SQL file in XAMPP MySQL, first has to go to XAMPP MySQL bin then do the command standard Mysql import command line.

XAMPP Path in MacOS

/Applications/XAMPP/bin

1	/Applications/XAMPP/bin

./mysql -u <username> -p <database_name> < <sql_file>

1	./mysql -u <username> -p <database_name> < <sql_file>

Example:

./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql

1	./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql