Execute SQL script to create tables and rows

mysql terminal

I have a database that I created using the CREATE DATABASE statement in the terminal and I have a .sql file full of statements creating tables and rows.

I just wanted to know what was the command line to execute that .sql on the database I created?


In the MySQL interactive client you can type:

source yourfile.sql

Alternatively you can pipe the data into mysql from the command line:

mysql < yourfile.sql

If the file doesn't specify a database then you will also need to add that:

mysql db_name < yourfile.sql

See the documentation for more details:

  • Executing SQL Statements from a Text File

If you have password for your dB then

mysql -u <username> -p <DBName> < yourfile.sql

Related

How to check if a variable is an IEnumerable of some sort
Is there a way to get a <button> element to link to a location without wrapping it in an <a href ... tag?
Computing an md5 hash of a data structure
How to remove the character at a given index from a string in C?
Getting the java.lang.reflect.Method from a ProceedingJoinPoint?
How to clear PermGen space Error in tomcat
Error in local storage - NS_ERROR_FILE_CORRUPTED - firefox
How to transition to a new view controller with code only using Swift
Progress Bar while download file over http with Requests
Let $G$ be a non-trivial group with no non-trivial proper subgroup. Prove that $G$ cannot be infinite group.
convergence of the series $\sum u_n, u_n = \frac{n^n x^n}{n!}$ for $x>0$
Find the angle ADE of the given triangle.