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" 

Popular posts from this blog