Posted by J.O. Aho on 10/13/77 11:39

Tony Peardon wrote:
> I was looking througn the manual, trying to make sence out of all this sql
> stuff, when I discovered that I could define my tables in a text file,
> rather than typing them at the mysql> prompt.
> "How do I 'run' this file?"

If you have managed to get into the mysql prompt, then you seen the following
message from the mysql:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 110 to server version: 4.0.18-log

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

Then you may should have typed that "\h", if you had done that you had got the
following list:

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Network Support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as
new delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute a SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

For server side help, type 'help contents'

If you had been this curious then you had seen the '\.' option and you would
have solved the problem yourself quite easily.

mysql> \. yourfile.sql


If you don't want to get into mysql prompt, then you can use following command
line:

mysql -uadmin -pXXXXX < yourfile.sql

change the "admin" to the username you use to login to your mysql, the "XXXXX"
part need to changed to your password.


//Aho

[Back to original message]