How to import .SQL file in MY SQL DATABASE

Krunal Rana
Jan 9, 2023

--

step 1 :

open mysql command line client

step 2 :

show database ;

[check previous databases ]

crate database database_name ;

[to store .sql tables in new datbase i crate new datbase here | u can skip this step ]

step 3 :

Open cmd as admin {right click on cmd and open as admins }

mysql -u root -p databsename < “.sql file path with file name and extantion”

--

--

Krunal Rana
Krunal Rana

No responses yet