Import SQL file command line

[Ronin]

I have a SQL generated file and I would like to import it to MySQL via the command line. Can anyone post the method to do this?

[mylegoh]

From msdos:
mysql -u username -p password < textfilewithsqlstatments.sql

From unix:
similar, but it has been a while so I cannot remember the exact syntax, it should not be too different.

[Ronin]

yeah, it is the same command in Linux. I forgot to post that I figured this out afterwards.

[Lop]

Except the password doesn't need to be there. Just:

mysql -u username -p < textfile.sql

[Atmaweapon]

i had to include the database name:
mysql -u <username> -p <database> <textfile.sql>

[zerostar]

heya

I am copying a .sql db form a production server to a dev server. Do I have to place the .sql file in a certain directory to do the import from the cmd line? I can't seem to be able to complete the import.

I'm running the latest revision of wampserver.

thanks!

[Jordan]

If you execute it as:

mysql -u <username> -p <database> textfile.sql

Then the file needs to be in the same directory you are currently in. If you know where the file is you can do:

mysql -u <username> -p <database> /path/to/file/textfile.sql

[zerostar]

Thanks for the reply

I'm still getting an ERROR 1604 (syntax). Here is what I'm entering at the mysql> prompt:

mysql -u username -p databasename < dbtoimport.sql;

is this correct?

btw - this is from a sqldump from the Prod server.

[Jordan]

No, remove the ;

[zerostar]

hmm...tried that but it just goes to the next line. sorry 'bout the n00bness

I already created the DB and I'm just trying to import the structure and data from the dump file - is this procedure correct? They are named the same - would that present this problem?