How do I load a local .SQL file into MySQL?

Question

I have a 56mb file on my web server, and I would like to (I think) use INFILE to load a filename.SQL file into mysql.

I don't really want to upload it because that will just take too long, but I would like to just use the local file on the system to import into mysql. The file contains the table creation instructions already so I don't need to specify the target, just execute the SQL as is in the file.

Do you have access to a shell on the server? You need to use the mysql client program to import a sql file. — Cfreak
– Cfreak, Commented Jul 8, 2011 at 19:15

trailmax · Accepted Answer · 2011-07-08 20:02:10Z

4

login to mysql command line environment and do:

mysql> source file_name.sql

answered Jul 8, 2011 at 20:02

trailmax

35.2k25 gold badges150 silver badges238 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Mior · Accepted Answer · 2014-11-10 15:34:22Z

2

The easiest way is to pass it in as a stream from the command prompt. Something like this:

mysql -u theuser -D thedatabase < filename.SQL

edited Nov 10, 2014 at 15:34

Michael Mior

28.9k10 gold badges95 silver badges118 bronze badges

answered Jul 8, 2011 at 19:18

thunderflower

1911 silver badge5 bronze badges

Collectives™ on Stack Overflow

How do I load a local .SQL file into MySQL?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related