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

Post a Comment

Popular posts from this blog

How to set Alias for Laravel in ubuntu?

There are following steps for setting the aliases: 1. To begin with, open the bash terminal and head to the home directory. 2. Then, check if there is a .bash_aliases file: ls -a 3. In case the file does not exist, we have to create it: touch .bash_aliases 4. Open the file with a text editor and add the alias. For example: alias pa='php artisan' 5. Then, save the file and exit. 6. Restart your terminal and try in your project root directory with pa Some Aliases: alias pa="php artisan" alias pas="php artisan serve" alias pac="php artisan cache:clear" alias paoc="pa optimize:clear"
Read more

Best Website Links

Forex Related Sites Link: *For Calculation: http://www.luckscout.com/leverage-margin-balance-equity-free-margin-and-margin-level-in-forex-trading/ TOP Wesite List:   http://biglistofwebsites.com/list-top-websites-on-slider   TAlly :  http://www.rtslink.com/TallyXMLTags.htm http://www.ncsmindia.com/chapter-10-displaying-information-from-tally/ Check your site contains malicious or not: http://sitecheck.sucuri.net Info about your site: http://builtwith.com/ SRS: http://www.microtoolsinc.com/Howsrs.php http://www.acommerce.asia/ http://www.srstravels.net/clients.php http://www.mgts.co.in/case_study_viatical_service_outsourcing.html http://techwhirl.com/writing-software-requirements-specifications/ http://www.jaysonjc.com/programming/how-to-write-a-software-requirements-specification-srs-document.html http://www.tricity.wsu.edu/~mckinnon/cpts322/cpts322-srs-v1.doc Theme · Admin: o http://www.daveism...
Read more