I'm running the latest version of Minixamp for windows to host a development version of my phpBB forum site. I have taken a backup from the production forum site which gives a 30mb SQL file. I try to restore this on my development system but it just hangs or fails. I also tried to execute the SQL file using myphpadmin, but that warns of a file size limit for the SQL files. Is there some underlying mySQL limitation on the size of file I can load and process? Is there any way I can increase that file size to cope with my database restore?
If I split the file into smaller portions it will load. That worked OK with files of up to about 1mb, but fails with larger files.