How to 'Import SQL file to MySQL'

In this video you can learn how to import .sql file to mysql database

Description:

1. First you need .sql file to be stored in any drive or directory
2. Then you need to check where database with same name exist or not using command SHOW DATABASES;
3. If exist remove database if no problem using command DROP DATABASE DATABASE_NAME;
4. Then create database again using command CREATE DATABASE DATABASE_NAME;
5. Then enter into database using command USER DATABASE_NAME;
6. Then type command SOURCE F:/DATABASE_FILE_NAME.SQL
7. F:/ is the drive where .sql file is stored.

[watariovids]

Literally the only good video on this, everyone else always skips steps for some god damn reason.

[henrynnonyelu]

Very straight to the point.Thank you very much.

[aureliolorenzo]

This was exactly the info I was looking for! Thank you so much!

[mehulchoksi]

Was having this difficulty since quite a while. Thank you so much!

[radheshkhanna]

Thank You .... Only Solution that seems to be working
Can you please make another video on How to import all databases backup using Source Command

[MindScape]

SImple, concise and precise.. THANK YOU :)

[harshbardhansingh]

Best video as well as easy process. Thank u

[byeworld]

Such A great content. We need more videos.

[k.baskarkkb]

Good video . It helps to connect python to mysql.thanks lot

[rishikandwal]

Thank you so much sir, Simple and easy steps :)

[pallavigupta]

thanks you gave a simple way to import .sql file

[balajikumar]

Thank you so much for the video. It helps a lot and resolved my issue.

[ajinath]

thank you so much sir, your technique is working fine .

[Nagasuhas_M]

Thank you very much sir it helped me a lot i am so grateful to you

[DavidHergo]

Its a good video bro helped me a lot, thanks

[arnabsaha]

Thank you very much your video is really helpful.

[sirwrad]

excelent video brow is the best video about it in youtube.... thanks!

[test-bngr]

All good but one thing you should say to user to start xampp (mysql apache)

[ayushsharma-brlc]

Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL

[shubhamsulakhe]

If the text file isnt available in database then how I can add this