Creative, Informative and Entertaining Stuff for everyone

Wednesday May 23rd 2012

Categories

Archives

Calender

May 2009
S M T W T F S
« Apr   Jun »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Archive for May 26th, 2009

How to import data into mysql db from sql file

Open your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql Where mysqlUserName = Mysql User Name Password = Mysql User Password HostName [...]