Import contents of mysql table from a txt file from ssh

Asked Aug 29 '15 at 07:03

Active Aug 29 '15 at 08:02

Viewed 211 times

I am trying to import contents of mysql table from a txt file.

I have already created dump of individual tables in .txt file. I then tried to import this txt file in my local server by LOAD DATA LOCAL INFILE. It worked fine locally. But when I tried to import using the same method in live. I am getting #1148 - The used command is not allowed with this MySQL version. I searched and followed steps from these two threads:

But it didn't work out. Now I am finding way to import these contents into the table from those txt files by ssh. Any help on how to do that from SSH will be great.

BTW, I am using mediatemple DV

TIA

edited May 23 '17 at 11:52

Community

asked Aug 29 '15 at 07:03

syd

You can't redirect it to the `mysql` executable? – Ignacio Vazquez-Abrams Aug 29 '15 at 08:04
I don't know about that. It's first time I am working on such big database with more than 5 million rows. Can you please clarify, what to I need to do? – syd Aug 29 '15 at 08:09
`cat dump.sql | mysql -uroot -ppassword -hlocalhost` – Shi Sep 01 '15 at 00:33

Import contents of mysql table from a txt file from ssh

0 Answers0