Here I explain how to upload database with cmd.
First create database in phpmyadmin. For example ahd_db1
Now copy your sql file and paste in this path : MySql/bin
for example your sql file is db.sql so paste it xampp/MySql/bin/db.sql
Now run this command :
D:\xampp\mysql\bin>mysql -uroot ahd_db1< db.sql
Wait for some time. If execution ncompleted than it will display noraml cmd. For cross check go to phpmyadmin and check your database.
First create database in phpmyadmin. For example ahd_db1
Now copy your sql file and paste in this path : MySql/bin
for example your sql file is db.sql so paste it xampp/MySql/bin/db.sql
Now run this command :
D:\xampp\mysql\bin>mysql -uroot ahd_db1< db.sql
Wait for some time. If execution ncompleted than it will display noraml cmd. For cross check go to phpmyadmin and check your database.
No comments:
Post a Comment