How to Import a Database with MySQL from the Terminal?

Importing a Database with MySQL via Terminal: A Comprehensive Guide

Importing a database into MySQL from the command line is a common task for database administrators. While the process may seem straightforward, it requires precision in syntax.

Question:

How can I import a database using MySQL from the terminal? I'm having trouble understanding the exact syntax.

Answer:

To import a database with MySQL from the terminal, follow these steps:

1. Open a terminal window.
2. Navigate to the directory containing the SQL dump file.
3. Execute the following command:

mysql -u <username> -p <databasename> < <filename.sql>

Example:

If you wish to import a database named "wp_users" from a file named "wp_users.sql," using the username "root" and the password "Password123," you would run the following command:

mysql -u root -pPassword123 wp_users < wp_users.sql

Additional Notes:

• Remember to replace "" with your actual MySQL username and "" with the name of the database you wish to import.
• If you want to provide the password directly (a less secure method), use the following command:

mysql -u <username> -p<password> <databasename> < <filename.sql>

• For further reference, consult MySQL documentation on executing SQL statements from a text file.

For Windows Users:

• Navigate to the MySQL/bin directory within the Command Prompt (CMD).

Conclusion:

Importing a database with MySQL from the terminal is a simple process, but adhering to the correct syntax is crucial. By following these instructions carefully, you can efficiently import your databases and manage them effectively.

The above is the detailed content of How to Import a Database with MySQL from the Terminal?. For more information, please follow other related articles on the PHP Chinese website!