Upload a Database

Discussion in 'Databases' started by justforlebanon, Nov 1, 2007.

0
  1. #1
    Hello need help to upload a database
    i downloaded my sql database
    it is .SQL
    now i need help how to upload it
    i guess i should go to phpmyadmin
    then click on import
    is this correct?
    thx
     
    justforlebanon, Nov 1, 2007 IP
  2. pixads

    pixads Well-Known Member

    Messages:
    2,015
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    145
    #2
    if you have phpmyadmin it's easy
    how big is the database?
     
    pixads, Nov 1, 2007 IP
  3. justforlebanon

    justforlebanon Peon

    Messages:
    193
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    around 50 Mega bytes
     
    justforlebanon, Nov 1, 2007 IP
  4. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #4
    PHPmyadmin may not be the right tool to import 50 MB db.

    Upload the .sql file to your server with FTP and
    use bigdump from ozerov.de/bigdump.php
     
    Kuldeep1952, Nov 1, 2007 IP
  5. justforlebanon

    justforlebanon Peon

    Messages:
    193
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thank u Kuldeep
    i will look into it :)
     
    justforlebanon, Nov 1, 2007 IP
  6. pixads

    pixads Well-Known Member

    Messages:
    2,015
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    145
    #6
    the other way is to split the database in 4 or 8 MB chunks and still use phpmyadmin
     
    pixads, Nov 2, 2007 IP
  7. izeaus

    izeaus Banned

    Messages:
    803
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I never knew this . Thanks Kuldeep1952 I also have a huge database which I need to download and then to upload .
     
    izeaus, Nov 2, 2007 IP
  8. Matbell

    Matbell Guest

    Messages:
    215
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    i have till now , imported 160 mb from phpmyadmin

    it did it very easily, then why use something else?
     
    Matbell, Nov 2, 2007 IP
  9. justforlebanon

    justforlebanon Peon

    Messages:
    193
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    because i guess it may have some errors while downloading or uploading
    the transfer via ftp is just better
    i guess :D
     
    justforlebanon, Nov 3, 2007 IP
  10. nikko999

    nikko999 Peon

    Messages:
    406
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Phpmyadmin is sexy, dont worry about the limit, just upload the database, once the limit has reached it will automatically break the operation, upload again, and it will continue from where it has stopped.
     
    nikko999, Nov 3, 2007 IP