Import SQL file into mysql

by

From the mysql console:

mysql> use DATABASE_NAME;

mysql> source path/to/file.sql;

make sure there is no slash before path if you are referring to a relative path… it took me a while to realize that! lol

More Related Contents:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Error Code: 2013. Lost connection to MySQL server during query
  3. MySQL Trigger after update only if row has changed
  4. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  5. MySQL Query to select data from last week?
  6. Using an Alias in SQL Calculations
  7. Can a table field contain a hyphen?
  8. Adding a leading zero to some values in column in MySQL
  9. View’s SELECT contains a subquery in the FROM clause
  10. Check for x consecutive days – given timestamps in database
  11. MySQL Insert Into from one Database in another
  12. How do I get the ID of multiple inserted rows in MySQL?
  13. How to insert data to MySQL with auto-incremented column(field)?
  14. Case statement in MySQL
  15. Replace Into Query Syntax
  16. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  17. Laravel join with 3 Tables
  18. Difference between two table structure
  19. MySQL query, MAX() + GROUP BY
  20. ERROR 1148: The used command is not allowed with this MySQL version
  21. How to insert a file in MySQL database?
  22. How to get multiple records against one record based on relation?
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Foreign key constraints: When to use ON UPDATE and ON DELETE
  25. Where does MySQL store database files on Windows and what are the names of the files?
  26. How to use a user variables in MySQL LIKE clause?
  27. How to speed up sql queries ? Indexes?
  28. MySQL: Computed Column
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment