Wednesday, January 19, 2011

How to restore large mySQL script file in to mysql server from console using xampp server on linux

## create DB then,
## Login to mysql prompt by using following command

/opt/lampp/bin/mysql -u root  

## then it will redirect to mysql prompt as follows

mysql>

## then login to require db by using use command

mysql>use <dbname>

## for help

mysql>\help

## To restore db kept SQL script file at root folder and run filloing command

mysql>\. <scriptfilename.sql>

No comments:

Post a Comment