I've searched for hours, there are many posts or tutorials but I couldn't run my batch script.
on dos prompt this code works fine:
-u root -h localhost -p******** siir_07 dumper.sql
but this gives error with batch:
"c:\program files\mysql\mysql server 5.5\bin\mysql.exe" "-u root -h localhost -p******** siir_07 dumper.sql"
the error is:
ERROR 1045 (28000): Access denied for user ' root -h localhost -p** siir_07 dumper.s'@'localhost' (using password: NO)
Z:\test.bat :
Z:\webserver\mysql\bin\mysql.exe -u test -p test < test.sql
When I run it from command line, everything is OK. So, try to remove quotes and redirect input using <.
You can also use source to execute sql script for example
mysql -u%DBUSERNAME% -p%USERPASSWD% -D%DBNAME% -e "source something.sql;"
you should redirect input from file using < and remove extra spaces:
mysql -uroot -p*** < dumper.sql
I would also suggest putting the username password, and most probabry charset parameters in a separate INI file and use it as follows:
mysql --defaults-extra-file=myconf.ini < dumper.sql
This solution worked for me:
mysql -u my_username -D my_database -p < test.sql
After this I got a prompt to enter my password, I did and everything worked.
it thinks this is your username
' root -h localhost -p** siir_07 dumper.s'
try changing the quotes around in your batch script
