hosted by liquidweb

Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Import large database without shell?

Forum Jump

Import large database without shell?

Reply Post New Thread In Hosting Security and Technology Subscription
Send news tip View All Posts Thread Tools Search this Thread Display Modes
Aspiring Evangelist
Join Date: Jun 2001
Posts: 358

Import large database without shell?

OK guys, here's the challenge. I'm supposed to put up a large database onto a client server. It goes without saying that when asked, client answers the question about having ssh access in the affirmative and when I get there he doesn't have ssh access. Challenge is that the database is 260 MB large and phpmyadmin just isn't going to cut it. It never cuts it with databases half the size of the ~51MB limit. Cutting and pasting into smaller files is the only workaround I can think of and will also take me all day. Is there any other idea you guys may have that might accomplish the import? I don't see a way to do the import with a file uploaded via ftp where I'd normally use ssh to import. Many thanks to you all...

|| - Law Forum and Legal Advice Site
|| Cheap VPS LLC - Discounted VPS Hosting

Sponsored Links
Junior Guru Wannabe
Join Date: Aug 2006
Location: Milton Keynes, UK
Posts: 52
There is a small php program which does this as I used it on a host who didn't allow SSH some years ago. Sorry to get your hopes up but I've searched and just can't find it. Just thought I let you know your search isn't in vain.

Otherwise get the client to ask his host to load it via SSH.

Junior Guru Wannabe
Join Date: May 2005
Posts: 65

Sponsored Links
Junior Guru Wannabe
Join Date: Mar 2005
Posts: 90
Perhaps this might help

Junior Guru Wannabe
Join Date: Dec 2005
Posts: 82
usually hosts have a time limit for php scripts (max_execution_time). The default value is 30 sec. If
upload time will take more then 30 sec and they have this won't work.

Probably you can consider uploading from cron if you have access. there you can use a simple shell script, something


mysql -u$DBUSER --password=$PASSWORD $PATH$DUMP > $DB


Web Hosting Master
Join Date: May 2006
Posts: 556
or set up a php.ini file to allow files so big to upload and set the timeout to be longer and place that in the phpmyadmin directory.


Related posts from
Title Type Date Posted
Database Company MongoDB Secures $80M to Fuel Growth Web Hosting News 2015-01-13 15:32:41
OpenStack Silicon Valley 2014: Video Interview with DBaaS Provider Tesora Whir Tv 2014-09-24 09:43:28
Linux Malware Operation Windigo Infects 25,000 Web Servers Web Hosting News 2014-03-19 11:44:53
MongoDB Offers Online Certification Program for Developers and Database Admins Web Hosting News 2013-10-30 14:27:37
Cloudant Merges BigCouch Code into Apache Open Source Database Web Hosting News 2013-07-22 17:55:14

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Log in with your username and password

Forgot Password?
WHT Host Brief Email:

We respect your privacy. We will never sell, rent, or give away your address to any outside party, ever.

Web Hosting News:
WHT Membership
WHT Membership



Welcome to

Create your username to jump into the discussion! is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.

(4 digit year)

Already a member?