How to populate database from file when in the MySQL console

Question

How can I populate a database from a sql file when I'm in the mysql console? LOAD DATA INFILE doesn't fit my problem. I want to populate the whole database, not only one table. mysql -u root -p database < file.sql won't work either. Because I cannot out of the mysql console.

I don't think there's a way to do it from the `mysql` command. Can you use MySQL Workbench? It has import/export. — Barmar, Mar 02 '13 at 10:55
http://stackoverflow.com/questions/5152921/import-sql-file-from-mysql-console — Markus Mikkolainen, Mar 02 '13 at 10:58

score -1 · Answer 1 · answered Mar 02 '13 at 10:26

-1

You want to bulk insert at commandline? Why not use mysqlimport

shell> mysqlimport [options] db_name textfile1 [textfile2 ...]

answered Mar 02 '13 at 10:26

Freddie Fabregas

1,101
1
7
16

I cannot out of the Mysql console. So I cannot use `mysqlimport`. – OrangeTux Mar 02 '13 at 10:30
1

I think I misunderstood you. You said "when I'm in the mysql console". What do you mean by "i cannot out of the mysql console"? – Freddie Fabregas Mar 02 '13 at 10:46
Excactly that ;). When I'm `exit` the console closes, I do not return to a shell. It's Windows... – OrangeTux Mar 02 '13 at 10:49

How to populate database from file when in the MySQL console

1 Answers1