- 3
- 147 163
Amarnath R
India
เข้าร่วมเมื่อ 4 ต.ค. 2015
This is one of the Java Based Projects Development and Training Videos Channel
How to "Import SQL file to MySQL"
In this video you can learn how to import .sql file to mysql database
Import SQL: th-cam.com/video/rPyspgbAx6I/w-d-xo.html
Export SQL 1: th-cam.com/video/xXWUggDBrRI/w-d-xo.html
Export SQL 2: th-cam.com/video/gNT5r7J9uCE/w-d-xo.html
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.
Import SQL: th-cam.com/video/rPyspgbAx6I/w-d-xo.html
Export SQL 1: th-cam.com/video/xXWUggDBrRI/w-d-xo.html
Export SQL 2: th-cam.com/video/gNT5r7J9uCE/w-d-xo.html
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.
มุมมอง: 137 972
วีดีโอ
Export MySQL Database Using Command Prompt
มุมมอง 2.6K8 ปีที่แล้ว
In the above video you can see how to create database in mysql and export the database using command prompt as .sql file 1. The command to create database is:- create database DATA_BASE_NAME; use DATA_BASE_NAME; 2. Export the database as .sql file:- a. Open the command prompt terminal type b. Mysqldump -u root -p DATABASE_NAME > F:/FILE_NAME.sql Then Press Enter c. Command prompt will ask for M...
How to "Export Database as SQL File From MySQL"
มุมมอง 7K8 ปีที่แล้ว
Import SQL: th-cam.com/video/rPyspgbAx6I/w-d-xo.html Export SQL 1: th-cam.com/video/xXWUggDBrRI/w-d-xo.html Export SQL 2: th-cam.com/video/gNT5r7J9uCE/w-d-xo.html This video will show you how to export database SQL file using Command Prompt The command to export as SQL file is mysqldump -u username -p F:/filename.sql then enter your mysql password then press enter For more tutorials visit: www....
Thanks dude very helpful
thank you, short and easy
merci
Best video. Thank you very much!
Hello Sir Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL
😘😘😘😘
Nice explanation. Thank you sir
Such A great content. We need more videos.
Thkuuuuu, very useful 🌸
Thank you so much for this
Thanks buddy 😊
This was exactly the info I was looking for! Thank you so much!
obrigado! me ajudou bastante!
Thanks brother😍
Thank you.
Save my life brother
This video really helped! Subscribed.
Best video as well as easy process. Thank u
Thank you. Simple to understand.
sencillamente un grande
Love you!
Its a good video bro helped me a lot, thanks
If the text file isnt available in database then how I can add this
All good but one thing you should say to user to start xampp (mysql apache)
Thank you for this!! So simple!
thanks a lot man!!!!
Thank you so much sir, Simple and easy steps :)
Thanks buddy...:)
Thanks for this video
thank you so much sir, your technique is working fine .
......nn si capisce nulla......perchè nn coglire pere ?
thank you bro
thanks
i made it omfg .thank you very much
i love u
Thnx bri
Thank you so much for the video. It helps a lot and resolved my issue.
Thanks very much!
Good video . It helps to connect python to mysql.thanks lot
Good Job!
и не одного русского, но видео помогло, thanks
Thank you
SImple,concise and precise.. THANK YOU :)
Literally the only good video on this, everyone else always skips steps for some god damn reason.
Thank you!!!!
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
THANK YOU SOOO MUCH
thanks
Thank you very much sir it helped me a lot i am so grateful to you
Thanks bro