SQL db question

miju

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

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

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.

miju

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

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.

miju

thanks squibs ill check that out now

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?

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

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