mysql import on windows

Question

I have a MySQL file, db.sql. I have tried to import it using:

mysql -uroot -p[password] db < db.sql

All I get is a listing of mysql commands, or I get a syntax error. The weird thing is I used this file last week and, as far as I know, I'm doing it the same way.

I create the database, then in command line enter the above but it's not working. I've tried being inside mysql and just at command line and nothing seems to be working.

Is there something I should be doing differently in windows or MySQL5? I don't know how the heck I got it to work the first time...

TIA

score 62 · Accepted Answer · answered Nov 21 '09 at 02:01

62

Try this instead:

mysql -u root -p
(prompts for password)
use db;
source db.sql

answered Nov 21 '09 at 02:01

wallyk

56,922
16
83
148

3

You're my hero. Worked perfectly. – user80151 Nov 21 '09 at 02:08
1

don't forget to upload .sql file to bin folder :) – Payam Khaninejad Aug 14 '19 at 15:04
@PayamKhaninejad Note the context of the question. The OP already has the file right there. – wallyk Aug 14 '19 at 16:54
@wallyk in case someone like me came from Google – Payam Khaninejad Aug 15 '19 at 03:37
Yes, the alternative way worked for me thank you! – Shashank Shah Dec 15 '22 at 05:31

score 5 · Answer 2 · answered May 17 '12 at 01:46

5

I found out it is different to run this command from Windows Command Line (cmd.exe) and Windows PowerShell.

Using CMD.exe the command works okay, but in PowerShell I get this error:

mysql -uroot exampledb < exampledb.sql

The '<' operator is reserved for future use.

answered May 17 '12 at 01:46

abc

123
1
6

3

You can't use the < on Windows PowerShell ([see here](http://stackoverflow.com/a/2148816/1256062)) – tvdias Aug 08 '12 at 15:30

score 1 · Answer 3 · answered Dec 26 '12 at 18:55

If you are already logged in the try this it will be very useful, but depend upon the MySQL version, it works on MySQL 5.0

For log in if you are not already logged in.

mysql>[your password]

Other wise, use the database to which you want to import the SQLDump file by command.

mysql>use [your database name]

And then give source the database Dump file path as blow command(If not works the copy Dump database file to the bin folder where the MySQL installed for eg. "C:/programfiles/mysql/mqlserver5.0/bin")

mysql> source [dataBasePath+name.sql or dataBaseName.sql]

score 0 · Answer 4 · answered Nov 21 '09 at 01:53

0

Not sure if your example was a typo or not, but for starters you need to have a space in between your flags and their values, roughly like this:

mysql -u root -p [password] db < db.sql

answered Nov 21 '09 at 01:53

jaywon

8,164
10
39
47

I've tried it both ways. I still just get a long listing of all the commands. – user80151 Nov 21 '09 at 01:56
You can't use the < on Windows PowerShell ([see here](http://stackoverflow.com/a/2148816/1256062)) – tvdias Aug 08 '12 at 15:29

score 0 · Answer 5 · answered Sep 02 '14 at 21:13

This perfectly works

mysql>[your password]

Other wise, use the database to which you want to import the SQLDump file by command.

mysql>use [your database name]

And then give source the database Dump file path as blow command(If not works the copy Dump database file to the bin folder where the MySQL installed for eg. "C:/programfiles/mysql/mqlserver5.0/bin")

mysql> source [dataBasePath+name.sql or dataBaseName.sql]EG: source C:.....sql

I am using mysql server 5.5

score 0 · Answer 6 · answered Mar 25 '11 at 01:38

0

I've been using PHP script called "BigDump": http://www.ozerov.de/bigdump.php

answered Mar 25 '11 at 01:38

Jani Kajala

193
1
5

score 0 · Answer 7 · answered Sep 13 '21 at 17:23

0

In Windows PowerShell, you can pipe in the contents like so:

Get-Content db.sql | mysql -u root -p [password]

answered Sep 13 '21 at 17:23

naXa stands with Ukraine

35,493
19
190
259

mysql import on windows

7 Answers7

Linked