Execute SQL script to create tables and rows

by

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

Leave a Comment

404 Not Found

Not Found

The requested URL was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.