Ipb - Restoring Database

Discussion in 'Gaming' started by AM Nielz, Oct 10, 2006.

  1. AM Nielz

    AM Nielz Well-Known Member

    Age:
    32
    Posts:
    3,887
    Likes Received:
    0
    Joined:
    Apr 22, 2005
    Location:
    Steenwijk, The Netherlands
    Hi,

    A while ago my site was hacked, and everything was gone. That's why we decided to get the forum back up again, with a back up of our database (forum posts, members etc.). The problem is; The database is too big to upload and too big add in withPHPMyAdmin manually. Anyone has suggestions?
     
  2. Blooper008

    Blooper008 Well-Known Member

    Posts:
    1,535
    Likes Received:
    0
    Joined:
    Mar 17, 2005
    Contact your host, send them the file and they will probably help you with it. Is it compressed? And have you tried uploading it through the forum administration page?
     
  3. .eclipse

    .eclipse Senior Member

    Posts:
    317
    Likes Received:
    0
    Joined:
    Sep 10, 2005

    Most forum administration pages do not have uploading SQL, you normally just import it through PHPmyadmin. But yes, Devastation pointed out to contact your host and send them then an SQL file.

    You could always try gzipping it first and importing it.
     
  4. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    How big is the file?

    You should be able to import it, but knowing the file size would help.
     
  5. Blooper008

    Blooper008 Well-Known Member

    Posts:
    1,535
    Likes Received:
    0
    Joined:
    Mar 17, 2005
    He's talking about IPB, which does has a script to upload a a backup to the forum.
     
  6. Zohair

    Zohair Formerly zohBOT

    Posts:
    6,128
    Likes Received:
    0
    Joined:
    Dec 18, 2005
    Location:
    Cave
    Yeah that's correct ^ .
     
  7. .eclipse

    .eclipse Senior Member

    Posts:
    317
    Likes Received:
    0
    Joined:
    Sep 10, 2005
    Yeah he spams ^.
     
  8. HydrogeN

    HydrogeN Well-Known Member

    Posts:
    2,532
    Likes Received:
    0
    Joined:
    Sep 7, 2004
    I run an IPB board, I have imported them before with some issues and no issues. But I wanted to know how big the file was to see if in fact it was too large to import.
     
  9. ZenShen

    ZenShen Well-Known Member

    Posts:
    48
    Likes Received:
    0
    Joined:
    Oct 12, 2006
    this happened to me, I had to split up the file. Split it somewhere after a table dump.
     
  10. Phili G

    Phili G Well-Known Member

    Age:
    33
    Posts:
    1,498
    Likes Received:
    0
    Joined:
    Oct 5, 2005
    Location:
    England!
    yeah I was gonna recommend spitting the database. How big is it?
     
  11. AM Nielz

    AM Nielz Well-Known Member

    Age:
    32
    Posts:
    3,887
    Likes Received:
    0
    Joined:
    Apr 22, 2005
    Location:
    Steenwijk, The Netherlands
    It's 7,7 mb
     
  12. Blooper008

    Blooper008 Well-Known Member

    Posts:
    1,535
    Likes Received:
    0
    Joined:
    Mar 17, 2005
    Then why you can't you upload it through Cpanel/forum administrator. If I'm correct the max file size is like 50MB ?
     
  13. johndapunk FTW

    johndapunk FTW Senior Member

    Age:
    32
    Posts:
    2,513
    Likes Received:
    0
    Joined:
    Jan 19, 2006
    Location:
    Palm Beach
    None the less, try splitting it up. I\'ll show you spots in the SQL where you can Cut & Paste into another file, unfortunally I\'m at school right now and I can\'t say exactly off the top of my head.
     

Share This Page