如何從終端導入 MySQL 資料庫？

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.

以上是如何從終端導入 MySQL 資料庫？的詳細內容。更多資訊請關注PHP中文網其他相關文章！