How to import sql file in mysql


In last tutorial we seen how to take db dump in mysql. In this post we will see how to import DB sql file. In mysql if your sql file is less than 12 MB then you can import it through workbench like phpmysql or sqlyog. But if file size is larger than 12 MB then we can import it through terminal in ubuntu or command line tool in windows.
dev@devender-G:~$ mysql -u root -p new_test_db < /home/devendar/filename.sql
Enter password:

That all in this post. Hope this is helpful to you.

About the Author: devender kumar

java/j2EE developer

Comments are closed.