Results 1 to 6 of 6
  1. #1

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

  2. #2
    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. #3

  4. #4
    Join Date
    Mar 2005
    Posts
    90
    Perhaps this might help http://www.ozerov.de/bigdump.php

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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •