import from file on mysql command prompt

[rlee923]

Hi,

I tried to search what I wanted for a while, but I was unsuccessful.

What I want to know is a way to import a file with table schema, and values in the format as
insert(....) - basically an sql file -
into a table on the mysql database using mysql command prompt.

I read reference manual and tried LOAD DATA, but it didn't work.

Please be patient with me since I am newbie 😃.

Thanks a lot in advance.

Cheers

[sneakyimp]

RTFM or STFI! From the manual:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

comes this

mysql db_name < your_file.sql

[rlee923]

Hmm this is a command from shelll right?

I wanted to know if there is any command that you can use on mysql prompt.

Hehe , thanx for the reply anyway

Cheers.