1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How Do I Upload A 81MB Forum (Phpbb) DB

Discussion in 'MySQL' started by calcalmx123, Apr 24, 2008.

  1. #1
    how can i do it ????

    please help me
     
    calcalmx123, Apr 24, 2008 IP
  2. mobilebuzz

    mobilebuzz Banned

    Messages:
    1,108
    Likes Received:
    101
    Best Answers:
    0
    Trophy Points:
    0
    #2
    import it using phpmyadmin
     
    mobilebuzz, Apr 24, 2008 IP
  3. jezzz

    jezzz Notable Member

    Messages:
    4,884
    Likes Received:
    190
    Best Answers:
    0
    Trophy Points:
    200
    #3
    Choose! Dump something like that to backup the Database easily
     
    jezzz, Apr 24, 2008 IP
  4. calcalmx123

    calcalmx123 Well-Known Member

    Messages:
    1,498
    Likes Received:
    58
    Best Answers:
    0
    Trophy Points:
    195
    #4
    will it time out or something ? and howlong will it take ?
     
    calcalmx123, Apr 24, 2008 IP
  5. mobilebuzz

    mobilebuzz Banned

    Messages:
    1,108
    Likes Received:
    101
    Best Answers:
    0
    Trophy Points:
    0
    #5
    i don't think it should time out
    however what else you can do is
    upload it using ftp and than import using the absolute path
    and for the time it will take
    it solely depends on your net speed and the server speed
     
    mobilebuzz, Apr 24, 2008 IP
  6. calcalmx123

    calcalmx123 Well-Known Member

    Messages:
    1,498
    Likes Received:
    58
    Best Answers:
    0
    Trophy Points:
    195
    #6
    can someone please explain this for me how can i do it i will give you rep :D
     
    calcalmx123, Apr 24, 2008 IP
  7. Whippet75

    Whippet75 Well-Known Member

    Messages:
    1,599
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    155
    #7
    I can do this for you for a small fee ;)
     
    Whippet75, Apr 24, 2008 IP
  8. sawz

    sawz Prominent Member

    Messages:
    8,225
    Likes Received:
    808
    Best Answers:
    0
    Trophy Points:
    360
    #8
    google "bigdump"

    thank me later. :D
     
    sawz, Apr 24, 2008 IP
    pipes likes this.
  9. EGS

    EGS Notable Member

    Messages:
    6,078
    Likes Received:
    438
    Best Answers:
    0
    Trophy Points:
    290
    #9
    Don't do that.

    Pay me $50 and I'll do it. :D
     
    EGS, Apr 24, 2008 IP
  10. mobilebuzz

    mobilebuzz Banned

    Messages:
    1,108
    Likes Received:
    101
    Best Answers:
    0
    Trophy Points:
    0
    #10
    wow
    it is amazing
    isn't very less for this job
    and any service tax
    education tax
    import duty
    excise and custom
    is it also included in 50$ :D


    no need to pay anyone
    just open your cpanel
    go through the phpmyadmin
    try it yourself and i am surely u will do it
    if you stuck anywhere i am here to help you anytime for free
    it might take some time to reply but i will surely do that
     
    mobilebuzz, Apr 24, 2008 IP
  11. Whippet75

    Whippet75 Well-Known Member

    Messages:
    1,599
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    155
    #11
    You cannot import an 81mb db using PhpMyAdmin ! It will simply timeout.

    hence the reason why people are charging money as it will take time to import a db of this size using SSH or a browser.
     
    Whippet75, Apr 24, 2008 IP
  12. pipes

    pipes Prominent Member

    Messages:
    12,766
    Likes Received:
    958
    Best Answers:
    0
    Trophy Points:
    360
    #12
    Use bigdump, phpmyadmin struggles even with tiny db's, at least it did for me recently.

    http://www.ozerov.de/bigdump.php read carefully the intructions on what you have to do, i found it very useful.
     
    pipes, Apr 24, 2008 IP
    sawz likes this.
  13. SimThePhpCoder

    SimThePhpCoder Well-Known Member

    Messages:
    949
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    108
    #13
    thats how you do it ;]
     
    SimThePhpCoder, Apr 24, 2008 IP
  14. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #14
    If you are in a shared hosting environment then you should upload your sql file using ftp and ask your hosting provider to import it for you using shell.

    But if you are on a dedicated server then you have a couple of options. Either increase file size limit to upload big files or upload using ftp and use command line options to import database.

    I always prefer to import big databases using shell. This is the most reliable way (I never faced any problem with shell import even with 20GB+ database).
     
    mwasif, Apr 24, 2008 IP
  15. ozaki12

    ozaki12 Active Member

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    86
    #15
    Hey mate,

    1) Ask your host for SSH privallages and login via an ssh client e.g putty (windows)
    2) Upload your SQL file via FTP to your hostings directory e.g /home/username/
    3) Login to SSH, and type ls -l just to make sure you can see the sql file, if not.. type cd directory (directory being where the file is stored)
    4) run this command, and change the 4 fields mysql -u username -p password databasename < databasefile.sql

    I'm sure that any decent hosting provider will at least allow jailshell for it's users.
     
    ozaki12, Apr 26, 2008 IP
  16. gsv13

    gsv13 Well-Known Member

    Messages:
    2,773
    Likes Received:
    114
    Best Answers:
    0
    Trophy Points:
    130
    #16
    ^^ Whats Jailshell ?
     
    gsv13, Apr 26, 2008 IP
  17. bond7007

    bond7007 Peon

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #17
    phpBB is 3 mb...... use fillezilla
     
    bond7007, Apr 27, 2008 IP
  18. parm

    parm Banned

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #18
    use filezilla to upload and if you have fast internet connection then no need to worry you can do it easy
     
    parm, Apr 27, 2008 IP
  19. pipes

    pipes Prominent Member

    Messages:
    12,766
    Likes Received:
    958
    Best Answers:
    0
    Trophy Points:
    360
    #19
    Filezilla to upload a MySQL Database?
     
    pipes, Apr 27, 2008 IP