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 


by Uki D. Lucas on Monday, June 02, 2008
find similar posts: ,
As an Amazon Associate I earn from qualifying purchases.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

apt quotation..

“A man should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects.”  by Robert A. Heinlein (author, aeronautical engineer, and naval officer)