Importing large db via ssh/telnet

New Member Joined: Aug 05, 2005 Posts: 19

Having always imported my databases manually via phpmyadmin I would like to know how I would go about importing a large db (approx 100mb) via ssh/telnet.

This is something I have no idea about and would appreciate any help on how to acheive this and what the command would look like.

TIA

Darryl

Sells PC To Pay For Divorce Joined: Posts: 5661

does this help,is almost the same question... [ Only registered users can see links on this board! Get registered or login! ]

Posted: Fri Aug 05, 2005 4:45 pm

So I take it that the sql file needs to be located on the server.

Would it work if it is still tarred or does it need to be untarred?

Posted: Fri Aug 05, 2005 4:50 pm

well im not that familiar with that stuff but i can imagine untarred..
i just tried to help and the search gave a nice result...
but another idea...
is it an idea that you ask your host to do this ?
For them its so easy ?
Just provide the file and voila...

Posted: Fri Aug 05, 2005 4:54 pm

It's not actually me thats doing it, it is a friend of mine who has just got himself a dedicated server because his site outgrew a shared environment, so the option of asking the host is not an option I assume.

He asked me to help and like I said earlier this is all foreign to me also. Sad

Posted: Fri Aug 05, 2005 5:07 pm

Possible that you can also use Big Dump.I´ve never tried it, but friends told me thats a very good tool.
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Fri Aug 05, 2005 5:34 pm

Thanks, I'll take a look. Smile

Posted: Thu Aug 11, 2005 4:49 am

Just to let anyone else know, bigdump worked perfectly for me with a 400mb sql.

Brilliant tool.