- Instant help with your Sql coding problems

Import an SQL file using the command line in MySQL

by Mike
Question:
How to import an SQL file using the command line in MySQL?
Answer:
mysql -u username -p database_name < file-to-import.sql
Description:

If you want to import data into your MySQL database using the command line use the mysql command. You need to define the username, password and the database where you want to import data from the SQL file. 

Reference:
MySQL command line reference
Share "How to import an SQL file using the command line in MySQL?"
Related snippets:
Tags:
importing SQL file, command line, windows
Technical term:
Import an SQL file using the command line in MySQL?
Trending snippets
Backup only certain rows from MySQL databaseGet last 30 days records in MySQLCreate INSERT statement for each record with mysqldumpBackup MySQL data onlyBackup MySQL database without locking tablesSkip tables in MySQL backupBackup MySQL schema onlyDelete all records from a table in MySQLCreate table in MySQLDelete records from MySQL tableSort MySQL resultsBackup only selected tables in MySQLGet current year in MySQLBackup MySQL databaseList all tables in a MySQL databaseFind MySQL data directory locationConvert INT to DATETIME in MySQLList databases on MySQL serverGroup by year of Unix timestamp in MySQLImport an SQL file using the command line in MySQL
Network articles
Send JSON data with PostmanCheck if date is valid in JavaScriptUse comments correctly in PHPHow to create custom checkboxes in TailwindCSSRemove arrows from number input in TailwindCSSAdd data attribute to element in JavaScriptPrettier stopped working in VS CodeAccess JavaScript object property with hyphenRemove protocol from URL with JavaScriptFix the TypeError: MiniCssExtractPlugin is not a constructorConvert string to kebab case in JavaScriptRound a number in JavaScriptChange font size in VS CodeSet line spacing in CSSPHP string to arrayCenter content within an elementSet type for useState React hook with TypeScriptCheck if element is hidden in JavaScriptGet yesterday's date in JavaCreate new dialect in Thymeleaf