17 replies to this topic

[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 database_name < textfilewithsqlstatments.sql

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

Edited by John, 15 July 2009 - 05:56 AM.

[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!

[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.

[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?

[zerostar]

ok figured out what my issue was :o and yes - n00bness at work...

I had already logged into mysql.exe when I was trying to execute the command. I had to back out to the bin directory and then run the command.

up and running (*yay!*)

[Crane]

From inside mysql you can paste the entire contents of the SQL dump. that will also work although I've not tested it.