mysql restore database script with create clause?

Question

mysql> -u username -p [database] < file.sql

restores database. I do not have a create clause in my dumped file, hence I need to create a database and then restore. I can do this to create.

mysql> create database [database];

Fair enough. Now how can I achieve the above restoration in one line? Is there anyway to restore a database by creating the database before that with a single line of code?

I can certainly live without it, but would be nice to know.. Thanks..

glglgl · Accepted Answer · 2011-08-12 08:33:47Z

5

(echo "create database XYZ; use XYZ;"; cat file.sql) | mysql -u username -p

could do the trick.

answered Aug 12, 2011 at 8:33

glglgl

91.5k13 gold badges157 silver badges230 bronze badges

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

2 Comments

glglgl Over a year ago

it outputs the given file after the output of the echo command. All together are piped into the mysqlprocess.

nawfal Over a year ago

This din work for me. I was preferably seeing for mysql solution itself. Something like mysql> -u username -p --create [database] < file.sql or so.. Anyway thanks, I learned something new..

Collectives™ on Stack Overflow

mysql restore database script with create clause?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related