How to import the database to mysql under linux?

 Just follow the below steps:  
 Method 1:  
      1. mysql -u root -p       
           //Enter password  
      2. mysql>use your_db_name  
      3. mysql>SET autocommit=0 ; source database_file.sql ; COMMIT ;  
 Method 2:       
      mysql -u username -p password db_name < file.sql  

Comments

Popular posts from this blog