How to import and export large Database of mysql using command prompt

Hello Friends,

You are facing problem with large database to import or Export.

In this blog i will give you some hint to how you can import your large database file from phpMyAdmin and also export large file from that.

let's take example for that so you can get more idea.

put file1.sql in c:\wamp\bin\mysql\mysql5.1.36\bin or other path which you want.

if you need to import large sql file into phpmyadmin and you have no password then use following syntax

c:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root database_name < file1.sql

Have You have password then use this one

c:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root -p psw database_name < file1.sql

if you need to Export large sql file from phpmyadmin and you have no password then use following syntax

c:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root database_name > file1.sql

Have You have password then use this one

c:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root -p psw database_name ? file1.sql