| Author |
Message |
darryl
New Member
Joined: Aug 05, 2005
Posts: 19
|
 Posted:
Fri Aug 05, 2005 3:46 pm |
 
|
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 |
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Fri Aug 05, 2005 4:37 pm |
|
does this help,is almost the same question...
|
|
|
|
|
|
darryl
New Member
Joined: Aug 05, 2005
Posts: 19
|
| 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? |
|
|
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| 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... |
|
|
|
|
|
darryl
New Member
Joined: Aug 05, 2005
Posts: 19
|
| 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.  |
|
|
|
|
|
Susann
Moderator
Joined: Dec 19, 2004
Posts: 3143
Location: Germany:Moderator German NukeSentinel Support
|
| 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.
|
|
|
|
|
darryl
New Member
Joined: Aug 05, 2005
Posts: 19
|
| Posted:
Fri Aug 05, 2005 5:34 pm |
|
Thanks, I'll take a look.  |
|
|
|
|
|
darryl
New Member
Joined: Aug 05, 2005
Posts: 19
|
| 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. |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
