how to import .mysql file into the MySQL database? -
i have import data file news120m_stanford_lemma_np_pruned.mysql
new database on mysql 5.5 getting error :
mysql> mysql -u username -p -h localhost jobim_stanf < c:\program files\mysql\mysql server 5.5\data\jobim_stanf.mysql error: unknown command '\p'. error: unknown command '\m'. error: unknown command '\m'.
what correct command importing such file?
the command correct :
mysql -u {username} -p {databasename} < file_name.sql
the problem spaces in path
of sql file. you'll have add quotation marks ""
around :
mysql -u username -p -h localhost jobim_stanf < "c:\program files\mysql\mysql server 5.5\data\jobim_stanf.mysql"