Jan 162010
How to execute SQL file with MySQL
Answer:
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
Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.
How to execute SQL file with MySQL
Answer:
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
