import dumb files into mysql5.1 in windows

Question

I am using mysql5.1 server. I want to import sql dumb file using command prompt. and I also tried the following,

MySQL> -u {username} -p {database_name} < filename

am getting an error for the above code.

and I also tried with `mysqldumb -uroot {username} -proot {database} < {filename}` — Anto Robinson, Sep 30 '13 at 08:55

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

filename.sql should be in server. You can load the data if your filename.sql in client.

EDIT:
Check here and here

edited May 23 '17 at 11:50

Community

answered Sep 30 '13 at 08:55

chinna_82

Is there a need to specify the file extension also in query? – Anto Robinson Sep 30 '13 at 09:05
I tried the following from your above link `MySQL>source < {complete location of the file};` and am getting an error like _Failed to open file '{file path}',Error:2_ – Anto Robinson Sep 30 '13 at 10:32
where you keep your filename.sql? – chinna_82 Oct 01 '13 at 01:24
**C:\Users\anto\Desktop\DB_Dumb** – Anto Robinson Oct 01 '13 at 05:37
where is your database...in your local or server. if in server you need to copy the `filename.sql` to server. The server have no access to your local. – chinna_82 Oct 01 '13 at 05:40
Yeah my database in server. and how to copy this file to server? – Anto Robinson Oct 01 '13 at 07:15
create the same path in server. copy this file and paste in server location. Whats ur email? – chinna_82 Oct 01 '13 at 07:50
ssarobinson@gmail.com – Anto Robinson Oct 01 '13 at 08:35

Anto Robinson · Accepted Answer · 2013-10-03T04:37:42.537

0

Finally found an answer for my question. we could import the dumb file in the following way:

1.From the command prompt go to the root of the server

 C:\Program Files\MySQL\MySQL Server 5.1\bin>

2.Load the dumb file into the server using following command

 bin>mysql -uroot -p<server_password> {database_name} < {complete filepath}

Example:bin>MySQL -uroot -ppassword mydb < C:\Users\Anto\Documents\DB_Dumb

edited Oct 03 '13 at 04:37

answered Oct 01 '13 at 12:16

Anto Robinson

2 Answers2