PHP MyAdmin Help

Discussion in 'PHP' started by richardandrews2007, Dec 22, 2007.

0
  1. #1
    Hi All,

    My PHP dmin says i can import and run SQL file of only 8 M at the maximum but the SQL file I have is 15MB.

    Does anyone know wtahst the workaround over here.

    Many Thanks
     
    richardandrews2007, Dec 22, 2007 IP
  2. moodswing

    moodswing Peon

    Messages:
    188
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yes. I could help you with that.

    PM me or talk to me on my yahoo.

    regards,

    moodswing
     
    moodswing, Dec 23, 2007 IP
  3. coderbari

    coderbari Well-Known Member

    Messages:
    3,168
    Likes Received:
    193
    Best Answers:
    0
    Trophy Points:
    135
    #3
    I think u better export those files in 2 parts and then import them.
     
    coderbari, Dec 23, 2007 IP
  4. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,826
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #4
    You can change the values at php.ini

    memory_limit <value>M

    Just change it to a bigger value
     
    wisdomtool, Dec 23, 2007 IP
  5. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    #5
    what wisdomtool said is absolutely correct. it will help you ,go ahead
     
    kishore415, Dec 23, 2007 IP
  6. richardandrews2007

    richardandrews2007 Active Member

    Messages:
    794
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #6
    Thanks, but the thing is I do not have a PHP ini here, this is a 1and1 hosting PHP MyAdmin, I think I can't do anything with their servers, right?
     
    richardandrews2007, Dec 23, 2007 IP
  7. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #7
    I can help you with this also.. Let me know via PM if you are still needing help with the larger database.

    Boulder
     
    Boulder, Dec 23, 2007 IP
  8. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,826
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #8
    Depends on the configuration of the server, you should ask their support if you can do this via .htaccess. They would be in the correct position to answer you.

     
    wisdomtool, Dec 23, 2007 IP
  9. richardandrews2007

    richardandrews2007 Active Member

    Messages:
    794
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #9
    Many Thanks for your help guys, the issue is resolved.
     
    richardandrews2007, Dec 23, 2007 IP
  10. olddocks

    olddocks Notable Member

    Messages:
    3,275
    Likes Received:
    165
    Best Answers:
    0
    Trophy Points:
    215
    #10
    upload first the database to your server by FTP then use SSH to issue mysqldump command.
    if you are on shared host just ask your host to import the database.
     
    olddocks, Dec 24, 2007 IP