import sql file to mysql db using shell commands 1

import sql file to mysql db using shell commands

USE yourdb;

SOURCE D:/My Folder with spaces/Folder/filetoimport.sql;

Here is what the above code is Doing:
1. It’s creating a new database called “yourdb”
2. It’s importing the file “filetoimport.sql” into the database “yourdb”
3. It’s closing the connection to the database

Similar Posts