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.

phpmyadmin upload database

Discussion in 'Databases' started by tony84, Dec 3, 2006.

0
  1. #1
    i have a database for a forum which is abou 200kb however i cant upload anything more thanabout 50kb, is this something that my host has set? and also as the database is gzip, is it something i can split up and upload in 3-4 sections?
     
    tony84, Dec 3, 2006 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    50kb is nothing ... do you mean 50 mb ? in that case the simplest solution is :
    extract the db file, split the file where the create table statement begins and upload it in parts using the import function (you may also get an error like : max execution time exceeded) which means you'll have to split it even further. If the file has single inserts (each insert is separate) then you can break these as well.
     
    maiahost, Dec 3, 2006 IP
  3. tony84

    tony84 Well-Known Member

    Messages:
    1,864
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    140
    #3
    no i mean 50kb, and my database is about 200kb, has about 200 members and its been zpped up.

    So its my host who is being too tight with the restrictions?
     
    tony84, Dec 3, 2006 IP
  4. weknowtheworld

    weknowtheworld Guest

    Messages:
    306
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I think you should unzip the file and just upload it... It should get done...
     
    weknowtheworld, Dec 8, 2006 IP
  5. Neptune

    Neptune Well-Known Member

    Messages:
    1,465
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    108
    #5
    For a database that small you can just copy and paste it into phpmyadmin.
     
    Neptune, Dec 9, 2006 IP