Believe it or not I tried mysql -p administrator -p pwd mydb < myfile.sql
and it would not worked, but when I got rid of the space it work
Yes, that's how it's supposed to work:
http://www.mysql.com/doc/en/mysql.html
mysql -uadministrator -upwd mydb < myfile.sql
I did not think that the spaces after the '-u' and the '-p' matter
It doesn't for other options. -p is special, because if you leave out the password value, that's how mysql knows you want to be prompted interactively for the password.
Thanks,
Nestor :-)
Nestor A. Florez
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]