Looking for a script similar to bigdump

Discussion in 'MySQL' started by scylla, Jan 20, 2010.

  1. #1
    I need a script similar to bigdump for importing my large (70mb database). I've done google search and all that brings up is stuff to import data into an sql database (an offline database) such as excel importing.


    ^^^^^^^^Not what I need.

    This is why I don't want bigdump. The vbulletin backups that I have as far as I know have "extended inserts" AKA super long lines (easy to tell if you open the sql & choose wordwrap). So I would like a simple mysql import software that takes the database and puts it into the database that is on the server.

    Right now I'm looking at http://www.hotscripts.com/category/php/scripts-programs/database-tools/ with these options ticked:
    *Total Rating
    *Free

    I'll be uploading to godaddy free hosting (with a file limit of 1mb via phpmyadmin)
     
    scylla, Jan 20, 2010 IP
  2. scylla

    scylla Notable Member

    Messages:
    1,025
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    225
    #2
    Found one. A vbulletin admin recommended these to me.. should help out anyone else who finds theirselves in a similar situation. I went with mysqldumper.

    Note: The only reliable method of restoring a database is with shell access via telnet or ssh. This is because restoring with a PHP script like that in phpMyAdmin can result in PHP timeout errors and an incomplete database. Please see the instructions here:

    http://www.vbulletin.com/docs/html/maintenance_ssh_restore

    Note: Some people have reported success with these scripts:

    MySQLDumper:
    http://www.mysqldumper.de/en/index.php

    MySQLHotxcopy:
    http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

    Bigdump (restore only):
    http://www.ozerov.de/bigdump.php
     
    scylla, Jan 20, 2010 IP
  3. CR1M1N4L

    CR1M1N4L Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Couldn't you just use mysql client itself?
    mysql -u USER -p DATABASE < dump.sql
    Code (markup):
     
    CR1M1N4L, Jan 21, 2010 IP
  4. scylla

    scylla Notable Member

    Messages:
    1,025
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    225
    #4
    Read the first link of the last post of mine lol, that method is listed there. kthxbye
     
    scylla, Jan 22, 2010 IP