MySQL – Execute SQL script

This entry is part 4 of 9 in the series: Administering MySQL from the command line

MySQL

Many times we need to run a SQL script and we do not have graphical tools such as: phpMyAdmin or Adminer so we need to use the command line and use the mysql shell and follow one of the following methods:

1. Execute SQL script in direct way

$ mysql -u user -p data-base < script.sql

2. Authenticate and then run SQL script

$ mysql -u usr -p data-base

Then

source script.sql;

Or

. script.sql;

If script.sql file is not found in the current directory, then you must specify the path where it is located

Further readings

– man mysql




Leave a Comment

Your email address will not be published. Required fields are marked *