Friday 3 April 2020

mysql database upload using command steps

Hello

I have given Simple step for how to upload database using mysql command


Step 1 CMD command : sudo mysql --host hostname --port 3306 -u databaseUsername -p
step 2 pass : of you system then enter  your db pass
step 3 : after login in mysql hit command : use databases;
step 4  : use your database
step 5 : mysql> source /home/jaydip/Downloads/sql.sql ( Path your database )
and then click on entered button

exmaple

Step 1 CMD command : sudo mysql --host localhost --port 3306 -u root -p
step 2 enter your password : test123
step 3 :  use database
step 4 : mysql> source /home/jaydip/Downloads/sql.sql ( Path your database )
and then click on entered button


No comments:

Post a Comment

Thank You For Comment