Database Size problem

[Golden_Eagle]

I have now got a large database that is getting to a size of about 4Mb when downloaded (dumped / uncompressed).

On my Web server everything seems fine. But when using said database on my home server (localhost) I am recieving Max Execution time of 30 second errors constantly.

How can I stop this from happening and is it likely to start happening on my web server soon?

[bcarl314]

Have you optimized the tables recently? That may help.

[Golden_Eagle]

Yeah. I tried that.

I would download it straight from my space. Plonk it on my localhost in excact same format and errors appear! :(

Can I stop the errors by editting something on my localhost? ie
php.ini?

[Golden_Eagle]

No-One got any ideas then?

Could this be script related?

It works fine online, but not on my localhost. So I suppose not....

I'm using phpdev5 at the moment from firepages.

Any got any clues to this problem I'm having?