Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

SQL db question

  • 21-06-2007 09:15PM
    #1
    miju
    Banned (with Prison Access) Posts: 8,483 ✭✭✭


    guys trying to restore a db in phpBB but SQL file is over 60mb . anytime i try to do it through the phpBB admin it hangs.

    can anyone recommend any other ways of restoring the db ?

    thanks


Comments

  • #2
    forbairt
    Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭forbairt


    Ok sounds like a problem with .... usually the 8 / 16 mb memory size ...with apache

    What you could do is split the file up into ... 10 chunks or something like that and import them individually :)


  • #3
    Winters
    Registered Users, Registered Users 2 Posts: 14,762 ✭✭✭✭Winters


    I had to do this before. I just ended up manually cutting the SQL file up into several chunks, i think it was about 8 different SQL files in total.

    Worked a treat, although took me several hours to get right.


  • #4
    miju
    Banned (with Prison Access) Posts: 8,483 ✭✭✭miju


    thanks guys thought thats what id have to do alright. muco appreciated


  • #5
    squibs
    Closed Accounts Posts: 975 ✭✭✭squibs


    best way is to ftp it to the host, then telnet in and use mysql -u user -p dbname < sqlfile
    This will be quick, but you need telnet access.
    You could also look at DBmanager professional free - it won't time out like phpadmin, but it's quite slow.


  • #6
    miju
    Banned (with Prison Access) Posts: 8,483 ✭✭✭miju


    thanks squibs ill check that out now :):)


  • Advertisement
  • #7
    matt-dublin
    Registered Users, Registered Users 2 Posts: 4,478 ✭✭✭matt-dublin


    sounds like a broadband issue, where phpbb is hanging because its waiting to upload the 60 mb file.

    what speed is your internet access upload?


  • #8
    forbairt
    Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭forbairt


    squibs wrote:
    best way is to ftp it to the host, then telnet in and use mysql -u user -p dbname < sqlfile
    This will be quick, but you need telnet access.
    You could also look at DBmanager professional free - it won't time out like phpadmin, but it's quite slow.

    get SSH access where available ... passwords over cleartext is a no no :)


  • #9
    forbairt
    Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭forbairt


    matt-dublin wrote:
    sounds like a broadband issue, where phpbb is hanging because its waiting to upload the 60 mb file.

    PHP's usual max default upload is I think set at 2 mbs ? ...max memory size is something like 8mbs ...

    He's trying to upload a 60mb file ... so I'd doubt its an upload speed problem .. unless the max execution time of 30 seconds is being exceeded ... which for a 60mb file it probably is


Advertisement
Advertisement