Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Jan 162010

How to execute SQL file with MySQL


If you already inside the mysql client, type

mysql> source /tmp/data.sql

Or you can pipe the file to mysql client

cat /tmp/data.sql | mysql -u root

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>