How Do I Correctly Import an SQL File into MySQL Using the Command Line?

Importing an SQL File via the MySQL Command Line

Importing data from an exported SQL file is a common task in MySQL administration. This guide walks through the necessary steps to import an SQL file using the command line.

Syntax Error Resolution

In the user's case, the "database_name < file.sql" command resulted in syntax errors. The correct syntax, using a SQL user with "-u" and providing a password with "-p", is:

mysql -u username -p database_name < file.sql

Database Creation

Regarding whether to create a database first, check the exported SQL file. If it does not contain a "CREATE DATABASE" statement (exported with "--no-create-db" or "-n"), then the database should be created manually before importing.

Additional Considerations

• Use the full path of the SQL file for better accuracy.
• Include "-R" and "--triggers" flags with "mysqldump" to preserve database routines and triggers during export.
• Make sure the MySQL user has adequate permissions to import the data.

The above is the detailed content of How Do I Correctly Import an SQL File into MySQL Using the Command Line?. For more information, please follow other related articles on the PHP Chinese website!