Mysterious mysqldump error
If there's a query that I can never successfully execute, that is mysqldump. No matter what I try, mysql will give me a 1064 syntax error.mysqldump -u user -ppassword dbname > dumpfile.sql doesn't work, nor does other variations of the query. However, mysql -u user -ppassword dbname < dumpfile.sql works just fine. What is the problem here?