How to Import a .sql File into MySQL via the Command Line?

MySQL Command Line SQL File Import Guide

Importing a .sql file into MySQL via the command line can be a hassle-free process. Whether you're transferring data to a new server or restoring a backup, understanding the correct syntax is crucial. This article will shed light on the necessary steps involved in importing a .sql file from a Windows Server 2008 R2 environment.

Syntax and Execution

The error you encountered with the command "database_name < file.sql" is related to missing options. To import a .sql file successfully, you'll need to provide the database name, username, and password, followed by the correct syntax:

mysql -u username -p database_name < file.sql

Remember to replace "username" and "database_name" with the actual values.

Additional Options and Notes

• Full Path: For seamless execution, provide the complete path to the .sql file (e.g., "C:pathtofile.sql").
• Routines and Triggers: To maintain the routines and triggers associated with the imported data, use the "-R" and "--triggers" flags with the mysqldump command when exporting the original file.
• Creating the Database: If the SQL dump doesn't contain a "CREATE DATABASE" statement, you may need to create an empty database in MySQL first before attempting the import.

Troubleshooting

• Incorrect Syntax: Double-check the syntax and ensure that all the options are correct.
• Invalid Credentials: Confirm that the username and password provided are valid.
• Database Permissions: Verify that the user you're using has sufficient permissions to import data into the database.

The above is the detailed content of How to Import a .sql File into MySQL via the Command Line?. For more information, please follow other related articles on the PHP Chinese website!