limit on size of SQL files?
Posted: 01. January 2005 21:35
Hi,
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.
Hilfe!
Paul
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.
Hilfe!
Paul