I have a data base named "mig". it has 10 tables. now i want to create a same database in another system so I am using
mysqldump -u root -p root mig >file.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
dump -u root -p root mig >file.sql' at line 1
mysqldump -u root -proot mig >file.sql;
mysqldump -u root mig> file.sql
mysqldump is not a MySQL command, it is a command line utility. You must call it from your shell command line. I hope you are not calling this from MySQL prompt.