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.
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