Importing a Database with MySQL from the Terminal

Importing a database into MySQL using the terminal can provide a convenient way to manage data. To execute this task effectively, follow the steps outlined below:

Using the command line, you can access the MySQL prompt. The syntax for doing so is:

mysql -u username -p database_name

Enter your username, password, and the target database name in place of the placeholders.

Once connected to the database, you can import the desired data file using the following command:

You can also provide the absolute path of the SQL file in the command.
For example:
mysql -u root -p wp_users 
Alternatively, if you wish to avoid prompting for a password, you can include it directly in the command:
mysql -u root -pPassword123 wp_users 
Please refer to the official MySQL documentation for further details.
Note: If using Windows, navigate to the MySQL/bin directory in the CMD using the "cd" (change directory) command before executing the above commands.