How to Import mysql database using command line?

Mysql has rich features for users like they can easily import and export database, create table, relations, store procedures, triggers etc.

In the same way mysql has own command to import and export the mysql database.

1. First find the mysql executable.
   you can open the terminal in ubuntu/Mac or command line in windows to check whether mysql is installed globally or not.
   
   mysql --version
   
   Output:
   
   mysql  Ver 8.0.19 for macos10.15 on x86_64 (MySQL Community Server - GPL)
   
   if the output is same as above then it’s installed globally. If the output is not as above then you need to find the installed mysql version and executable file.
   
   Steps to find mysql executable in ubuntu
   
   1. Install mysql-client
   
   sudo apt-get install mysql-client
   
   Steps to find mysql executable in windows
   
   1. Go to the folder of wamp/wamp
   
   E:\wamp\bin\mysql\
   
   and run the terminal in the folder.
2. for Import database type in terminal
   
   mysql -u username -p database_name < path_of_sql_file
   
   Example:
   
   mysql -u root -p test < /var/www/html/test.sql
   
3. For export database
   
   mysql -u username -p database_name > path_to_sql_file
   
   Example:
   
   mysql -u root -p test > /var/www/html/test.sql
   
   
   If you are getting errors while importing like
   
   mysql foreign key constraint error
   
   then you can find the line no. and remove that
   
   OR
   
   You can Disable foreign key checks in command line
   
   mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;"  -u root -p test < /var/www/html/test.sql
   
   Still getting errors?
   
   you can force mysql command to import with errors with option —force or -f
   
   mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;"  -u root -p -f test < /var/www/html/test.sql
   

Let’s start with quick easy steps: