How do I import an SQL file using the command line in MySQL?


Try:

mysql -u username -p database_name < file.sql

Check MySQL Options.

Note 1: It is better to use the full path of the SQL file file.sql.

Note 2: Use -R and --triggers to keep the routines and triggers of original database. They are not copied by default.

Note 3 You may have to create the (empty) database from MySQL if it doesn’t exist already and the exported SQL don’t contain CREATE DATABASE (exported with --no-create-db or -n option), before you can import it.

Related Posts:

  1. How do I import an SQL file using the command line in MySQL?
  2. ERROR 1148: The used command is not allowed with this MySQL version
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. MySQL – Operand should contain 1 column(s)
  7. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. MySQL create table if not exists and insert record only if table was created
  10. How do I use properly CASE..WHEN in MySQL
  11. How can I do a FULL OUTER JOIN in MySQL?
  12. MySQL query String contains
  13. What’s the difference between VARCHAR and CHAR?
  14. Case statement in MySQL
  15. How to declare a variable in MySQL?
  16. MySQL Cannot Add Foreign Key Constraint
  17. How to split the name string in mysql?
  18. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  19. mysql Foreign key constraint is incorrectly formed error
  20. MySQL: Invalid use of group function
  21. How can I return pivot table output in MySQL?
  22. Compare dates in MySQL
  23. MySQL “WITH” clause
  24. MySQL Multiple Joins in one query?
  25. Error Code: 2013. Lost connection to MySQL server during query
  26. MySQL syntax for Join Update
  27. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  28. how to drop partition without dropping data in MySQL?
  29. MySQL combine two columns into one column
  30. Simple way to calculate median with MySQL
  31. Error 1046 No database Selected, how to resolve?
  32. MySQL Error 1264: out of range value for column
  33. Remove duplicate rows in MySQL
  34. How to SUM and SUBTRACT using SQL?
  35. Cast from VARCHAR to INT – MySQL
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. How do you force mysql LIKE to be case sensitive?
  38. MySQL – UPDATE multiple rows with different values in one query
  39. How to create a MySQL hierarchical recursive query?
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. MySQL OPTIMIZE all tables?
  59. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  60. MySQL – Get row number on select
  61. MySQL error: Unknown column in ‘where clause’
  62. How to truncate the text returned for a column in a MySQL query
  63. Using union and order by clause in mysql
  64. MySQL LIKE IN()?
  65. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  66. latency problems with wordpress install (from SQL import)
  67. How can I avoid duplicate primary keys in SQL import?
  68. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  69. Using group by on multiple columns
  70. Efficiently convert rows to columns in sql server
  71. Rename a column in MySQL
  72. SQL Server FOR EACH Loop
  73. SQL Query Where Field DOES NOT Contain $x
  74. How can I select the first day of a month in SQL?
  75. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  76. ORA-01861: literal does not match format string
  77. SQL Server Insert if not exists
  78. SQL Server: Invalid Column Name
  79. How do I reset a sequence in Oracle?
  80. SQL: Two select statements in one query
  81. SQL Server dynamic PIVOT query?
  82. What does Include() do in LINQ?
  83. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  84. Get everything after and before certain character in SQL Server
  85. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  86. Inserting Post Meta From SQL
  87. WordPress SQL LIKE request doesn’t work for fields with special symbols
  88. Export / import WordPress database
  89. SQL command to convert all tags in lowercase?
  90. How can I add a new row in a separate database when someone registers via WordPress?
  91. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  92. Use variable in SQL statement
  93. $wpdb->get_var – What value is returned when zero records are found?
  94. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  95. Inserting other fields to existing registration form in a WordPress theme
  96. Organising and completing posts (mark as read and hide)
  97. can’t delete a row from post_meta table
  98. SQL error on restoring database
  99. If meta_key exists then don’t select this post?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment