MySQL: How to import a sql dump.. inside mysql command line?

Question

I often keep a shell open to a remote server where I'm spending a lot of time in mysql. Exiting mysql and logging back in seems like a pain I shouldn't have to deal with if I just want to run a sql file.

When I'm running MySql from the command line, how can I run a dump file?

Right now, I'm using the same approach outlined in this post.

Community · Accepted Answer · 2017-05-23 12:06:24Z

1

mysql> use db_name;
mysql> source backup-file.sql;

You may want to take a look at this answer: https://stackoverflow.com/a/17666285

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Mar 16, 2015 at 4:53

PixelOcelot_guest

111 bronze badge

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

Collectives™ on Stack Overflow

MySQL: How to import a sql dump.. inside mysql command line?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related