Thursday, February 2, 2012

How to import too large sql file thru mysql console

We have the too large the Databases from some places.
How can we import this large sql files thru mysql console


Step 1 :
First go to mysql console


Step 2 :
Give the password to go to the commend prompt.


Step 3 :

use db_name; 
--After that enter the DB name what ever you create in your phpmyadmin.. 


Step 4 :
 \. c:\exact_path_of_sql_backup.sql 
--After that give the above command with the exact path of the sql file name


Step 5 :
It automatically fill the DB and Tables.


Step 6 :
After finish this, you can see this DB and Table into your phpmyadmin page.



No comments:

Post a Comment