Results 1 to 6 of 6
Hybrid View
-
09-08-2006, 08:10 AM #1Disabled
- Join Date
- Jun 2001
- Posts
- 383
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...
-
09-08-2006, 09:16 AM #2Junior 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.
-
09-08-2006, 09:39 AM #3Junior Guru Wannabe
- Join Date
- May 2005
- Posts
- 68
Have a look here
http://membres.lycos.fr/uqiqi/page_v...sPage=news.php
-
09-08-2006, 04:29 PM #4Junior Guru Wannabe
- Join Date
- Mar 2005
- Posts
- 90
Perhaps this might help http://www.ozerov.de/bigdump.php
-
09-08-2006, 08:29 PM #5Junior 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
-
09-08-2006, 09:00 PM #6Web Hosting Master
- Join Date
- May 2006
- Posts
- 560
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.