hosted by liquidweb


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

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
  #1  
Old 09-08-2006, 08:10 AM
badhat badhat is offline
Web Hosting Guru
 
Join Date: Jun 2001
Posts: 342

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...

__________________
|| TheLaw.com - Law Forum and Legal Advice Site
|| Cheap VPS LLC - Discounted VPS Hosting



Sponsored Links
  #2  
Old 09-08-2006, 09:16 AM
duplu duplu is offline
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.

  #3  
Old 09-08-2006, 09:39 AM
Seaniboy Seaniboy is offline
Junior Guru Wannabe
 
Join Date: May 2005
Posts: 65

Sponsored Links
  #4  
Old 09-08-2006, 04:29 PM
xfob xfob is offline
Junior Guru Wannabe
 
Join Date: Mar 2005
Posts: 90
Perhaps this might help http://www.ozerov.de/bigdump.php

  #5  
Old 09-08-2006, 08:29 PM
ngsupb ngsupb is offline
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 limi...it won't work.

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

#!/bin/sh
DB="in.db"
DUMP="db.sql"
DBUSER="user_name"
PASSWORD="password"
PATH="/home/user_name/backupdb/"

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

__________________
--
**Portfolio**



  #6  
Old 09-08-2006, 09:00 PM
IceCreamMan IceCreamMan is offline
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.

Reply

Related posts from TheWhir.com
Title Type Date Posted
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
Phoenix NAP Responds to Customer Feedback with New Cloud Features Web Hosting News 2013-02-19 17:09:09
Samsung Ventures Backs Cloudant Database as a Service Web Hosting News 2013-02-08 14:10:26


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
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com 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?