Monday, June 2, 2008

MySQL: Running SQL script from a file

uki@MacBookPro:~/Documents/workspace/CSD $  mysql -u USER_NAME -p DATABASE_NAME
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51b MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \. /Users/uki/Documents/workspace/CSD/docs/db/csd_20080602a.sql