View Single Post

  #2 (permalink)  
Old 09-28-2007, 02:17 PM
kasimani kasimani is offline
Member
User
 
Join Date: Jul 2006
Posts: 77
Rep Power: 0
kasimani
Send a message via Yahoo to kasimani
Default

first confirm file has the structure and schema and having saved with sql extension.

now u can do 2 things
1: u can login in mysql and type "source" following by "path" of the file.
2: without logging in it, import it by issuing mysqldump or mysqlimport command.

mysqlimport -f /path/of/the/file -d <database>
Reply With Quote