Import Mysql db with different host cmd


import db using local wamp;

open cmd
path to your wamp server mysql
Like ::
cd D:\wamp\bin\mysql\mysql5.6.17\bin
mysql -h <host> -u <user> -p <pass>
eg. mysql -h 192.168.0.200 -u <user> -p <pwd>
it will give screen like

mysql>

Now

mysql>source <source of you pure sql file no zip>

eg. mysql>D:/db.sql;

eg. mysql>D:\db.sql;
it should star importing

hahahahahahhahahahahah
enjoy………………………..!

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s